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 the assignment. You have five tasks:

1. Review this source for how to createSQL 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 createSQL PRIMARY KEY How to Create Add to Existing Table.
4. Review this source for how to createSQL FOREIGN KEY How to Create in SQL Server with Example.
5. Review this source for how to createSQL SERVER JOINS Tutorial INNER, LEFT, RIGHT, OUTER

What to Submit

• Upload screenshots for each of the above in a Word file explaining your process and what problems you experienced.
• All screenshots should be full screenshots. The instructor needs to see your name as the database name.

Inventory Store Employee Inventory_ID (PK) Quantity Store_ID (PK) Employee_ID (PK) Store_Name Employee_Name Location Role Contact_Number Contact_Number Employment_History Transaction Product Customer Transaction_ID (PK) Transaction_date Product_ID (PK) Payment_Method Product_Name Customer_ID (PK) Total_Amount Description Customer_Name Category Customer_Number Price Purchase_History Manufacturer Supplier Supplier_ID (PK) Supplier_Name Contact_Number