Term Project
Term Project
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 – High 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. Use standard notational form to describe each table. Table-name (field, field1, field2…) underline the primary key for each table.
8) Include a functional dependency analysis
9) Include all Primary and Foreign Key designations (the primary key list should be the same as in step 7), and an explanation of why each identified field is a primary key or foreign key.
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.
You should have submitted your term project proposal in Week 5 for approval by the instructor and submit the completed work in the final week in a Word Document (1,000 word minimum) Relevant parts of the Term Project Proposal may be incorporated in the above outline, modified from earlier versions/submissions as needed