Create a set of requirements that will be used to create the ER Diagram in Step
Create a set of requirements that will be used to create the ER Diagram in Step 2.
Create an ER diagram (using ERDPlus) that contains at least five entities and at least four binary relationships. At least one of the relationships should be many to many. Show all attributes of all entities.
Map the ER diagram you created in Step 2 into a relational schema containing the relations (with their attributes) and the referential integrity constraints (i.e. arrows pointing from foreign keys into their sources). Use ERDPlus to draw the mapped relational schema.
Summarization: You will deliver a document (.pdf) containing 4 items:
Item 1: Title Information containing the following:Header: Project Phase I, Name
Project Title: e.g. “Dental Center Database” or “Music Company Database”
Item 2: Requirements
Item 3: ER Diagram
Item 4: Mapped Relational Schema I have attached homework from the past to use as an example; it is only to be used as an example and has nothing to do with this assignment.CriteriaRatingsPts
This criterion is linked to a Learning OutcomeProfessionalism10 ptsFull Marks0 ptsNo Marks
10 pts
This criterion is linked to a Learning OutcomeCorrect Use of Tools and Techniques
The approach followed was logical and where necessary was supplemented with well documented assumptions.
Submission demonstrates that sufficient time and effort were given to the assignment (0-10 pts.)10 ptsFull Marks0 ptsNo Marks
10 pts
This criterion is linked to a Learning OutcomeAccuracy10 ptsFull Marks0 ptsNo Marks
10 pts
Total Points: 30