Find Us On: Facebook Twitter Rss Feed Blog
Need To Register? Sign Up Login

Proposal of Term Project - Term Project

rattrapbr
rattrapbr 


A.) Proposal of Term Project 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 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). B) Term Project 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. 11) Create a MS Access Database of your Term Project Design 12) Make sure it is normalized and it properly reflects the Primary Keys that you designed 13) Make sure that you populate the fields of the database with at least 3 data sets (3 rows) 14) You will need to create 2 Forms, and in the notes section of the assignment explain how they will be used 15) You will need to create 2 Reports and also explain who will use them and how. Attachments Tags Clarifications

Answers

Proposal of Term Project - Term Project - Solution

dickersonka
dickersonka 



Attached is the solution to the Proposal of Term Project - Term Project

This DOES NOT include the extra credit. If you need the extra credit let me know and I will add it in there.
Attachments Screenshots
Purchase Answer