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. Note Each entity must have entity name, attributes (fields), and primary key Place maximum and minimum cardinality to each relationship . . c Use Crow's foot notation Scenarios Question 1 Scenario: This diagram represents theelationships between bride and groom in a mariage relationship Bride Groom Question 2 Scenario: This diagram represents the assignment of school representatives in a textbook publisher. Each representative is responsible for several colleges. However, not all colleges have been assigned a sales representative College Representative Question 3 Scenario: This diagram represents scholarship applications in a financial aid office. It is possible that some scholarships have not been applied for by anybody. Applicant Scholarship Question 4 Scenario: This diagram represents the locations of all offices on a university campus. Of course, each building has one or more offices and each office belongs to one building Building Office Question 5 Scenario: This diagram represents the assignment of residents in a student residence hall. At some points, some apartments may be vacant. Resident Apartment Question 6 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