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.

f). A product may be written in many orders.

This is my answer for the question ABOVE.

This is the list of the things I got wrong. Please help me undetstand why I got it wrong

Extra entities COMPANY : -2 each

Extra FK in the STORE : -3 points

Missing bridge entity between ORDER and PRODCUT: -10

EXTRA FK in the PRODUCT table: - 5 points

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_CODE