This assignment allows students to demonstrate their skills in the area of designing relational databasesto satisfy specific business rules and requirements. The deliverables for this assignment include an EntityRelationship Diagram and detailed documentation describing the database design and structure.
In this assignment you will be provided with a description of an application (below) to create an entityrelationship diagram (ERD) and design accompanying table layout using sound relational modelingconcepts and practices. The relationships between the entities and the attributes for the entities will beidentified and described. This database will provide the foundation for the follow-on assignment. Thefollowing paragraphs provide the background and summary of the business requirements.
1) Determine and list your entities. Then create relationship sentence pairs between thoseentities that are related. You should not have any many-to-many relationships.
2) Create an entity/relationship diagram (ERD) showing all your entities, attributes, andrelationships. Sketch your ERD by hand or use a drawing program. Your diagram must be on asingle page. All entities should be related to at least one other entity. Your ERD should have allone-to-many relationships and not have any many-to-many relationships.
3) Create metadata that describes the table created from each entity and the column created fromeach attribute in the ERD. Particular attention will be given to the proper specification ofall primary key (via “PK”) and foreign key (via “FK”) columns in the table layouts. These shouldmatch your ERD exactly