Create a set of requirements that will be used to create the ER Diagram

Create a set of requirements that will be used to create the ER Diagram in Step 2. (Make enough requirements to have at least 4 relationships). The requirements should include cardinalities explanations so that when you build your ER diagrams the cardinalities can be added. Example: The doctor worked in one and only one hospital would indicate that the relationship between the doctor and hospital was mandatory and 1.
Give a brief introduction to your database. What is the database used for? What is being recorded?
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.(all entities need one or more attributes)
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.
Create the SQL statement from the relational schema. Use ERDPlus to create the statements


Buy plagiarism free, original and professional custom paper online now at a cheaper price. Submit your order proudly with us



Essay Hope