ShopX Database Design & Implementation

In this project, participants step into the role of a data analyst at ShopX, a growing e-commerce startup. They are tasked with creating the company’s first database system to store essential information about customers, products, sales, and employees. The goal is to build a structured foundation that supports future data analysis and reporting.

Learners will design and implement a SQL Server database (ShopX_DB) by creating tables, applying the correct data types, and inserting realistic sample records. The focus is on understanding how to structure data properly, manage auto-increment and manual IDs, and enforce rules around required vs optional fields.

Throughout the project, participants will engage in key stages including:

• Database creation – setting up ShopX_DB in SQL Server.

• Table design – defining four core tables (Customers, Products, Sales, Employees) with appropriate columns and data types.

• Data population – inserting sample records into each table, ensuring realistic and consistent values.

• Data verification – running SELECT queries to check inserted rows.

By completing this exercise, learners will gain hands-on experience in SQL fundamentals, including creating databases, designing tables, inserting data, and working with identities vs manual IDs—skills that form the backbone of any database-driven project.