Data Modelling & SQL Language: Database Design and Report for UShop

This report details the design and implementation of a relational database for UShop, an online retail company. The report begins with an introduction to the project and an overview of database concepts, followed by conceptual modeling, including the identification of entities such as CUSTOMER, EMPLOYEE, ORDER, and PRODUCT. The report then moves into logical modeling, detailing the normalization process to ensure data integrity and reduce redundancy, leading to an enhanced Entity-Relationship Diagram (ERD). The relational schema, physical model, and creation scripts are presented, along with an ER diagram created in phpMyAdmin and the table structure. Insertion scripts and sample data are included to demonstrate database population. The report concludes with a summary of the database design process and references used. The project aims to provide a robust and efficient database solution for managing UShop's customer, employee, order, and product information.