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

Please assist 1. Based on the Crow's Foot ERD below: a} list

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!