Data Modeling and Table Normalization
1.Create a Crow’s Foot ER diagram for each of the following business rules. The diagrams should clearly describe and identify each entity and show relationships. Show all cardinality, primary keys, and foreign keys. Use verbs to clarify your relationships. Show only the attributes that are contained explicitly in the case/ business rules.
2.You should also make and document any reasonable assumptions where you feel the case is vague, ambiguous, or missing any data necessary to meet the requirements.
3.Simplify M: N relationships, if any.
4.You may develop the diagram on paper and submit the scanned version or you may use any relevant software.