/CZ2007-Lab5

CZ2007 Introduction to Databases: MSSQL Scripts to emulate the RDBMS of an E-Commerce Company

CZ2007 Lab 5 MSSQL Scripts

Schema Name: SSP4G4_Master

Order to run the files in:

  • Create_DB
  • Employee
  • Complaint_Staff
  • Users
  • Products
  • Shops
  • Inventory
  • Orders
  • Order_Items
  • Comments
  • Comments_on_Comments
  • Comments_on_Products
  • Review
  • Complaints
  • Complaints_on_Comments
  • Complaints_on_Products
  • Complaints_on_Shops
  • Price_History

Alternatively, you can run Master_DB_Dump.sql directly instead.