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

Based on the ERD: 

 

 

• CREATE all tables
• INSERT data - add at least 10 records for each table
• TEST the implementation - Write SQL statements to test the implementation

 

Tasks: Review the resources below to complete this assignment. You have five tasks:

 

**** Upload screenshots for each of the above in a Word file explaining your process and what problems you experienced.

 

1. Review this source for how to create SQL Server Database — Create, Alter, Drop, Restore.
2. Review this source for how to create  SQL Server Table — CREATE, ALTER, DROP [T-SQL Examples].
3. Review this source for how to create SQL PRIMARY KEY — How to Create & Add to Existing Table.
4. Review this source for how to create SQL FOREIGN KEY — How to Create in SQL Server with Example.
5. Review this source for how to create SQL SERVER JOINS Tutorial — INNER, LEFT, RIGHT, OUTER

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