You should select a data storage problem of your interest and identify the various pieces of data that should be stored in a database. Then, in the actual Term Project, take it through the normalization process and design the actual database tables (see Assignment Term Paper for complete details of this).
You should submit your term project proposal in Week 5 for approval by the instructor and submit the completed work in the final week.
A go or no-go decision will be made for the term project subject area.
The Proposal for the Term Project, MS Word doc - 500 words minimum, should include:
1) Name and main idea of the project
2) Purpose and goal of the project
3) Possible users and administrators
4) How is this work being done now, without the database and how will the database specifically improve the process
5) Data elements to be involved: entities, attributes
6) Platform to be used: what type of database. (i.e. Short term will use MS Access, for ease of use and prototyping but long term will switch to a more robust platform like MS SQL, or Oracle, or remain in MS Access)
7) Other interesting related points
Part 2 Due March 20
You should select a data storage problem of your interest and identify the various pieces of data that should be stored in a database.
Make sure that your Term Paper follows the following format/outline:
1) Term Paper Abstract
2) Purpose and goal of the project
3) Users and administrators
4) How is this work being done now, without the database and how will the database specifically improve the process
5) Data elements to be involved: entities, attributes - Detailed Level
6) Platform to be used: what type of database. (i.e. Short term will use MS Access, for ease of use and prototyping but long term will switch to a more robust platform like MS SQL, or Oracle, or remain in MS Access)
7) Take the database through the normalization process and design the actual database tables.
8) Do include the functional dependency analysis
9) Do include any Primary and Foreign Key designation, as needed, as well as an explanation of why you designated them as such.
10) Document the whole process and information in MS Word document. Especially make sure that you include the description of the various entities, attributes in detail, their inter-relationship and the way the database is going to be used.