Question: Hi , I need an E - R diagram for the following relations using crow's foot notation. It is for a sports shoe database and
HiI need an ER diagram for the following relations using crow's foot notation. It is for a sports shoe database and I need help with possible entities, I can't have a customer entity. Please show the relationships between all the entities.
This is what I have so far.
Shoe Brand Nike
ModelID eg Air Max Dunk Low
Gender
Size
Type eg Running, Lifestyle, Training
Price
Shoe Brand Addias
ModelID eg Ultraboost, Yeezy
Gender
Size
Type eg Running, Lifestyle, Training
Price
Supplier
SupplierID
SupplierName
SupplierAddress
SupplierCountry
Manufacture
ManufactureID
ManufactureName
ManufactureAddress
ManufactureCountry
Store
StoreID
StoreAdd
StorePhone
StoreLocation
Inventory
StoreID
ProdID
QtyOnHand
OrderLine
LineNumberID
OrderID
ProdID
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
