Answer Happy

just answer what is required, and make the answersimple
The purpose of this project is to develop a working relational database for a real world application. In this project students will be able to learn database design methodology for relational database and create a database which can store data efficiently, retrieve information effectively and free from data anomalies. Project Application Examples The list below includes examples of project applications (not limited to this list provided) that you may select from. More than one group is allowed to select the same topic. Teams copying other team's work or allowing their work to be copied by the others will receive ZERO on the project.
elopment Steps 1. Give a factual description of the proposed database application showing users requirements specification in simple English. 2. Identify and document the main entities types in the view of the enterprise which you have selected in your project and expressed in step 1. 3. Draw ER diagram. 3.1 Identify the important relationship types that exist between the entity types that you have identified. Check that each entity participants in at least one relationship. (10) 3.2 Determine the multiplicity constraints and other constraints of relationship types. (10) 3.3 Identify and associate attributes with the appropriate entity or relationship types. (5) 1 4. Identify the type of each attribute: primary key, simple/composite, singlevalued/multiple-valued, and derived. Document the attributes and prepare the data dictionary. 5. Evaluate the quality of the proposed DB design by using normalization, and prove that your ER has no problems. 6. Create tables in MS-Access/MS-SOL Server and showing the DB Diagram with relationships 7. Implement queries to retrieve and update.