Question
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). A company has many stores. Each store employs many employees but not more than 50. b). Each employee is employed by one (and only one) store. c). An employee may place many orders. d). Each order is placed by one employee. e). Each order may include many products. The number of products per order is limited to 2. d). A product may be written in many orders.
This is what I have for the question above. These were the notes regarding what I got wrong. Can someone help me understand why I got these wrong? Thank you
- Extra entities COMPANY
- Extra FK in the STORE
- Missing bridge entity between ORDER and PRODCUT
- EXTRA FK in the PRODUCT table
Store Employee Company COMPID PK PK ST CODE PK EMP ID (1,1) (1,1) ST_NAME EMP_FNAME COMP_NAME COMP_CITY COMP_STATE ST_LOCATION (1,1) (0,50) has EMP_LNAME FK1ST_CODE employs COMP_ZIP FK1 COMP_ID places (1,1) (0,0) Order Los PK ORD_CODE ORD_DATE FK1 EMP_ID (0,N) includes Product PROD CODE (0,2) PROD_QUANT PROD_PRICE FK1 ORD_CODEStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started