Question: Please assist 1. Based on the Crow's Foot ERD below: a} list the entities (8 points]. b} for each entity, list the attributes {El points},
Please assist

1. Based on the Crow's Foot ERD below: a} list the entities (8 points]. b} for each entity, list the attributes {El points}, the relationship cardinalities {El points} between the entities and the primary and foreign keys {3 points}. For example, there is a oneto many {1:MJ relationship between the CUSTOM ER and INVOICE entities. {What does the circle notation in 2 tell us?) 2. Write the business rules that are reflected in the following Crow's Foot ERIE-.123 points} N.B.: You need to list 8 business mles, one rule for each cardinalityr symbol. I have labelled the symbols from 1 to B in red. Label your business rules accordingly. The business rules should be stated in plain English. For example, here is the business rule (again. in plain English} corresponding to the symbol labelled 2: 2. Every customer can have many invoices. Exercise Objectives: Successful completion of this assignment supports this week's objective to use the conceptual data model and its core data-modeling blocks: attributes. entities. relationships, and cardinalities in order to generate and explain the business rules for the given data model
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
