Question

- Customers CustomerNo (PK) CustomerName PhoneNo Email - Sales Sales RepNo (PK) CustomerNo (FK) Sales RepName ? Purchase PurchaseID (PK) CustomerNo(FK) Dateltem Name SizeQuantity Purchase Detail Purchase DetailID (PK) Purchase (FK) ItemID (FK) - ItemID (PK) Stored (FK) Price Catagory tems Quantity Inventory Warehoused (FK) ItemID (FK) CostOfUnit UnitOnHand K Stores StoreID (PK) Store Location - Warehouse Warehoused (FK) WarehouseAddress WarehouseCity

          - Customers
CustomerNo (PK)
CustomerName
PhoneNo
Email
-
Sales
Sales RepNo (PK)
CustomerNo (FK)
Sales RepName
?
Purchase
PurchaseID (PK)
CustomerNo(FK)
Dateltem Name
SizeQuantity
Purchase Detail
Purchase
DetailID (PK)
Purchase (FK)
ItemID (FK)
-
ItemID (PK)
Stored (FK)
Price
Catagory
tems
Quantity
Inventory
Warehoused (FK)
ItemID (FK)
CostOfUnit
UnitOnHand
K
Stores
StoreID (PK)
Store
Location
-
Warehouse
Warehoused (FK)
WarehouseAddress
WarehouseCity

- Customers
CustomerNo (PK)
CustomerName
PhoneNo
Email
-
Sales
Sales RepNo (PK)
CustomerNo (FK)
Sales RepName
?
Purchase
PurchaseID (PK)
CustomerNo(FK)
Dateltem Name
SizeQuantity
Purchase Detail
Purchase
DetailID (PK)
Purchase (FK)
ItemID (FK)
-
ItemID (PK)
Stored (FK)
Price
Catagory
tems
Quantity
Inventory
Warehoused (FK)
ItemID (FK)
CostOfUnit
UnitOnHand
K
Stores
StoreID (PK)
Store
Location
-
Warehouse
Warehoused (FK)
WarehouseAddress
WarehouseCity

Added by Kathryn B.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Vaibhav Jain

Step 1

Database Definition Language (Create Table) for all tables: CREATE TABLE Customers ( CustomerNo INT PRIMARY KEY, CustomerName VARCHAR(50), PhoneNo VARCHAR(20), SalesRepNo INT, FOREIGN KEY (SalesRepNo) REFERENCES Sales(SalesRepNo) ); CREATE TABLE Sales Show more…

Show all steps

Thanks for your feedback!

Give an example of implementing Physical Database Design based on the ERD above, including: a. Database Definition Language (Create Table) for all tables b. Derived Attributes c. General Constraints Customers Sales CustomerNo (PK) SalesRepNo (PK) CustomerName CustomerNo (FK) PhoneNo SalesRepName Email Purchase PurchaseDetail Stores PurchaseID (PK) Purchase StoreID (PK) CustomerNo (FK) DetailID (PK) Store DateItemName Purchase (FK) Location SizeQuantity ItemID (FK) Quantity Items Inventory Warehoused (FK) ItemID (FK) CostOfUnit Warehouse ItemID (PK) Warehoused (FK) Stored (FK) WarehouseAddress Price WarehouseCity Category UnitOnHand