Question: Entity-Relationship Diagram (ERD) Homework: Based on the given scenario, develop the entity-relationship diagram for each question. If you discover while drawing the diagram that the

Entity-Relationship Diagram (ERD) Homework: Based on the given scenario, develop the entity-relationship diagram for each question. If you discover while drawing the diagram that the scenario is incomplete, makeup reasonable explanations to complete the story. Supply your explanations along with the diagram. I Each entity must have entity name, attributes (fields), and primary key Place maximum and minimum cardinality to each relationship. o Use Crow's foot notation Scenario:S Question 1 Scenario: This diagram represents the assignment of residents in a student residence hall. At some points, some apartments may be vacant. Resident Apartment Question 2 Scenario: This diagram shows that each customer can open several accounts (e.g.,checking and saving) and each account can belong to several customers (joint accounts). Of course, each customer must have at least one account to be claimed to be a customer. Each account must have at least one customer. Customer Account
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
