Welcome to the Bhejane Trading Store Database Normalization Project! In this project, you'll be diving into the world of SQL and applying your ninja skills to transform a denormalized database into a sleek, efficient system.
Bhejane Trading Store is an online retailer specializing in Covid essential items. The current struggle lies in managing the inventory system, and you've been enlisted as a consultant to solve this challenge.
Your mission, should you choose to accept it:
-
Denormalized Database: You will receive a denormalized database with two tables.
-
Normalization Task: Your primary task is to normalize the database into the third normal form (3NF). Refer to the attached Entity Relationship Diagram (ERD) as your guide on creating the necessary tables.
-
MCQ Test: After normalization, complete the multiple-choice questions (MCQ) test under the 'Predict' tab of Athena to validate your understanding.
-
Client Use-Cases: Throughout the normalization process, consider and address client (Bhejane Trading) use-cases for the database.
-
Data Anomalies: Identify and rectify data anomalies in SQL, ensuring a consistent and reliable database structure.
Follow these steps to embark on your database normalization journey:
-
Clone this repository to your local machine.
-
Review the provided denormalized database and ERD.
-
Begin the normalization process, creating tables according to the guidelines in the ERD.
-
After normalization, complete the MCQ test to reinforce your understanding.
-
Acknowledge and address client use-cases during the normalization.
-
Identify and resolve data anomalies to enhance the integrity of the SQL database.
-
/docs: Contains documentation files, including the ERD and any additional reference materials.
-
/sql_scripts: Place to store your SQL scripts for the normalization process.
-
/tests: Access the MCQ test under the 'Predict' tab of Athena.