Question: Make a ER model ( using crow foot notation ) for the following and please indicate the relationships. Customer CustomerID ( primary key ) FirstName
Make a ER model using crow foot notation for the following and please indicate the relationships.
Customer
CustomerID primary key
FirstName
LastName
Address
City
State
Zip
Phone
Email
Store
StoreID primary key
StoreAdd
StorePhone
StoreLocation
Inventory
StoreID Primary Key Store
ProdID Primary Key Product
QtyOnHand
Product
ProdID primary key
ProdName
ProdModel
ProdDescription
o Color and size
ProdPrice
Customer Order
OrderID Primary Key
CustomerID Foreign Key
ProdID Foreign Key
OrderDate
OrderStatus
ShippingDate
ShippingDestination
OrderLine
Line NumberPrimary Key
OrderIDForeign Key
ProdIDForeign Key
ProdQty
Discount
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
