Question: create a E-R diagram using crows foot model with the following: entities and attribute CEREAL_MANUFACTURERS (CM_ID, CM_Name, CM_HomeState) PRODUCTS (P_ID, P_Name) INGREDIENTS (I_ID, I_Name) SUPPLIERS
create a E-R diagram using crows foot model with the following:
entities and attribute
CEREAL_MANUFACTURERS (CM_ID, CM_Name, CM_HomeState)
PRODUCTS (P_ID, P_Name) INGREDIENTS (I_ID, I_Name)
SUPPLIERS (S_ID, S_Name, S_Phone, S_Street, S_City, S_State, S_Zip)
SUPPLIERS_PRICING (S_ID, I_ID, Price, Price_Expires
please include a chart similiar to this to show the relationship and cardinality of the entities above

Relationship Child WORK TRANS TRANS Cardinality Parent ARTIST WORK CUSTOMER CUSTOMER CUSTOMER ARTIST_INT Identifying ARTIST Type Nonidentifying 1:N M- Nonidentifying 1:N M-M Nonidentifying 1:N O-C MAX MIN 1:N M-O CUSTOMER ARTIST_INT Identifying 1:N M-O
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
