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

Hi,I need an E-R 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 (e.g., Air Max 270, Dunk Low)
Gender
Size
Type (e.g., Running, Lifestyle, Training)
Price
Shoe Brand (Addias)
ModelID (e.g., Ultraboost, Yeezy)
Gender
Size
Type (e.g., 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!