Exercise 1 Create a comprehensive list of business rules that specifies all entities, relationships, optionality constraints, and plurality constraints. Your proposed business rules must make provision for both the existing data and the provided business rules. Exercise 2 Create a logical entity-relationship diagram (ERD) using Crow's Foot notation that illustrates the relational database design described by the comprehensive business rules established in Exercise #1 above. All entities should be normalized to BCNF. Recall that logical ERDs must contain SQL-based constraints on the attributes, including primary and foreign key constraints.

Explain how and why in detail

Answer needed urgent