it 240 final project
louxiadefengjing
INTRODUCTIONTODATABASES-2019-2020Spring-5202020-1239PM.zipFinalProjectSpecs 2020.docx
IT-240 Intro to Databases Final Project: Applied Database Prototype Project
Project Overview and Description of Deliverables
The final project is accomplished in five sequential stages; each stage contributes to a final report:
1. Ideation - Identify the subject area, the business or organizational area of interest:
a. Describe the subject area briefly; no more than a few sentences should be necessary.
b. Use the case studeies in the texbook as examples
2. Project Definition - Describe the type of problem you wish to address with a database:
a. Describe the concern or problem you will try to address with a small database
Use the case studies as examples.
b. Provide examples of the current (possibly hypothetical) approach - include actual or mock-ups of relevant forms, reports, lists, etc.
c. Discuss how your approach should eliminate Delete/Update/Insert problems and help manage this issue in the future
3. Entity-Relationship/Data Modeling - Use the Vertabelo online tool for design work:
a. Develop appropriate conceptual model
b. Develop appropriate logical model
c. Develop appropriate physical model for implementation in Access
i. normalize the tables; provide the functional dependencies, PKs, and FK
ii. identify the constraints
d. Document your efforts with appropriate diagrams and explanations for the final approach you have chosen.
e. Provide examples of the create table SQL appropriate to each stage
4. Create Database Prototype - Test your final Physical Model from ER/Data Modeling:
a. Implement the tables structures you identified in ER/Data Modeling
b. Populate these tables with suitable amounts of illustrative data
c. Test your database application with relevant SQL queries
5. Summary: Results and Recommendations - Review and summarize your project results, recommendations; describe next steps, if any; be sure to address questions like:
a. Did your modeling work? Could you create a useful database prototype?
b. What went wrong? What did you fix, what didn't you fix?
c. What would be any next steps if you wanted to take this further?
Outline Template FinalProjectSpecs 2020.docx
Do NOT include any text in red; they are prompts.
[Name of Project]
[Your Full Name]
Ideation – this is an introduction to the business Identify the subject area, the business or organizational area of interest:
Describe the subject area briefly; no more than a few sentences should be necessary.
Use the case studies in the textbook as examples
Project Definition - Describe the type of problem you wish to address with a database:
Problems and concerns to be addressed
Identify the problems and frame them them in terms of Delete/update/insertion issues
Examples of the current approach - include actual or mock-ups of relevant forms, reports, lists, etc.
The new approach Discuss how your approach should eliminate Delete/Update/Insert problems and help manage this issue in the future
Entity-Relationship/Data Modeling - Use the Vertabelo online tool for design work:
Conceptual model brief discussion of the model/intro
i. The model
ii. SQL for the model
Logical model brief discussion of the model/intro
i. The model
ii. SQL for the model
Physical model for implementation in Access brief discussion of the model/intro
i. Function dependencies and the normalized tables
ii. Constraints, assumptions, and relations include a realtionship table
iii. Physical model and SQL
Database Prototype - Test your final Physical Model from ER/Data Modeling:
Implement the tables structures you identified in ER/Data Modeling
Populate these tables with suitable amounts of illustrative data
Test your database application with relevant SQL queries
Provide a brief discussion of the prototype.
Mention that it is attached.
Summary: Results and Recommendations - Review and summarize your project results, recommendations; describe next steps, if any; be sure to address questions like:
The DB Prototype Did your modeling work? Could you create a useful database prototype?
Issues with the model What went wrong? What did you fix, what didn't you fix?
Next Steps What would be any next steps if you wanted to take this further?
IT240 Example Project Proposal.docx
IT240 Example Project Proposal: Definition/Description
Project Description
My work at Wedgewood Pacific requires me to track computer assignments to all employees, maintain a list of locations where each computer should be found, and audit the equipment assignments and verify location periodically.
The basis for most of my work is a simple spreadsheet table, attached below.
This computer assignments spreadsheet is the only source of information about who has been issued which equipment, or if the equipment has been reissued, or if it has gone to 'SURPLUS'.
When employees report equipment problems, I have to use this table to begin to identify where they are located, the appropriate departmental codes needed to charge for the support ticket. This information is located in two other tables, one (EMPLOYEE) containing information on the employees and their locations, and another (DEPARTMENT) holding the departmental charging codes. Currently these tables are not linked together, so they must be searched by hand in order to identify important information.
For this project I plan to attempt to normalize the WPC Computer Assignments table into two or more relational tables, to test linking these new tables to our existing enterprise database, and to test query designs for tracking current assignments, equipment locations and budget codes for use in support/help desk incident charges.
Wedgewood Pacific Corporation
WPC Computer Assignments
SerialNumberMakeModelProcessorTypeProcessorSpeedMainMemoryDiskSizeAssigned ToDateAssigned ToDate
9871234HP Pavilion 500-210qe Intel i5-4530 3.006.0 GBytes 1.0 TBytes James Nestor15-Sep-14George Smith21-Oct-14
9871245HP Pavilion 500-210qe Intel i5-4530 3.006.0 GBytes 1.0 TBytes Rick Brown15-Sep-14Ken Numoto21-Oct-14
9871256HP Pavilion 500-210qe Intel i5-4530 3.006.0 GBytes 1.0 TBytes Tom Caruthers15-Sep-14
9871267HP Pavilion 500-210qe Intel i5-4530 3.006.0 GBytes 1.0 TBytes Heather Jones15-Sep-14
9871278HP Pavilion 500-210qe Intel i5-4530 3.006.0 GBytes 1.0 TBytes Tom Jackson15-Sep-14
9871289HP Pavilion 500-210qe Intel i5-4530 3.006.0 GBytes 1.0 TBytes George Jones15-Sep-14
6541001Dell OptiPlex 9020 Intel i7-4770 3.408.0 GBytes 1.0 TBytes James Nestor21-Oct-14
6541002Dell OptiPlex 9020 Intel i7-4770 3.408.0 GBytes 1.0 TBytes Rick Brown21-Oct-14
6541003Dell OptiPlex 9020 Intel i7-4770 3.408.0 GBytes 1.0 TBytes Mary Jacobs21-Oct-14
6541004Dell OptiPlex 9020 Intel i7-4770 3.408.0 GBytes 1.0 TBytes Rosalie Jackson21-Oct-14
6541005Dell OptiPlex 9020 Intel i7-4770 3.408.0 GBytes 1.0 TBytes Richard Bandalone21-Oct-14
6541006Dell OptiPlex 9020 Intel i7-4770 3.408.0 GBytes 1.0 TBytes Mary Abernathy21-Oct-14
Note:Computer reassignments are shown in the second set of "Assigned To" and "Date" Columns. If another reassignment is made, add another set of these columns.
Note:When a computer is retired from server, shown "Assigned To" as "Surplus"
Table of Contents.html
| INTRODUCTION TO DATABASES - 2019-2020 Spring - Final Project
2. Outline Template FinalProjectSpecs 2020 3. IT240 Example Project Proposal |
