In this assignment, U will continue to Build/Implement your Database in MS SQL Server. Employee Employee_ID (PK)

In this assignment, U will continue to Build/Implement your Database in MS SQL Server.

 

Transcribed Image Text:

Employee Employee_ID (PK) Employee_Name Role Contact Number Employment History Store Store ID (PK) Store Name Location Contact Number Inventory Inventory_ID (PK) Quantity Customer Customer_ID (PK) Customer_Name Customer Number Purchase History Transaction Transaction_ID (PK) Transaction_date Payment Method Total Amount Product Product_ID (PK) Product Name Description Category Price Manufacturer Supplier Supplier_ID (PK) Supplier_Name Contact Number Employee Employee_ID (PK) Employee_Name Role Contact Number Employment History Store Store ID (PK) Store Name Location Contact Number Inventory Inventory_ID (PK) Quantity Customer Customer_ID (PK) Customer_Name Customer Number Purchase History Transaction Transaction_ID (PK) Transaction_date Payment Method Total Amount Product Product_ID (PK) Product Name Description Category Price Manufacturer Supplier Supplier_ID (PK) Supplier_Name Contact Number