For this project you will choose a business below to design a database through the stages.

For my Database Design Project, I've chosen a fictional business named "GadgetGrove Electronics," a retail store specializing in the latest tech gadgets and electronic devices. The business aims to provide customers with a seamless shopping experience and personalized recommendations based on their preferences. GadgetGrove Electronics maintains a diverse product inventory, ranging from smartphones and laptops to smart home devices.

Scenario: GadgetGrove Electronics employs a database system to manage its extensive product catalog, customer information, and inventory. The database plays a crucial role in tracking sales, analyzing customer preferences, and optimizing stock levels. Customers can create accounts to receive personalized recommendations and track their purchase history.

Business Rules:

$1.$ Each product in the inventory must have a unique identification code.

$2.$ Customers must register with valid contact information to create an account.

$3.$ Products can have multiple variants $($e$.$g$.,$ different colors or storage capacities$).$

$4.$ The database must track the quantity of each product in stock.

$5.$ Discounts and promotions are applied based on customer loyalty and purchase history.

$6.$ Customers can add products to their shopping cart and proceed to checkout.

$7.$ The system must record sales transactions, including date, time, and purchased items.

$8.$ Suppliers are tracked in the database, including contact details and supplied products.

$9.$ Staff members have unique login credentials for accessing the system.

$10.$ The system generates reports on popular products, sales trends, and stock levels.

Entities and Relationships:

$1.$ Product Entity: Attributes include product ID$,$ name, price, and variant.

$2.$ Customer Entity: Attributes include customer ID$,$ name, contact information, and purchase history.

$3.$ Inventory Entity: Attributes include product ID$,$ quantity in stock, and reorder status.

$4.$ Transaction Entity: Attributes include transaction ID$,$ date, time, and purchased items.

$5.$ Supplier Entity: Attributes include supplier ID$,$ name, contact information, and supplied products.

$6.$ Staff Entity: Attributes include staff ID$,$ name, and login credentials.

Relationships:

$1.$ One$-$to$-$Many relationship between Product and Inventory $($One product can have multiple inventory entries$).$

$2.$ One$-$to$-$Many relationship between Customer and Transaction $($One customer can have multiple transactions$).$

$3.$ Many$-$to$-$Many relationship between Product and Transaction $($One transaction can involve multiple products, and one product can be part of multiple transactions$).$

$4.$ One$-$to$-$Many relationship between Supplier and Product $($One supplier can provide multiple products$).$

$5.$ One$-$to$-$Many relationship between Staff and Transaction $($One staff member can handle multiple transactions$).$

This database design will facilitate efficient operations for GadgetGrove Electronics and enhance the overall customer experience.

Your business must meet the following requirements:

$$ It must have $2$ or more master or parent tables

$$ It must have $3$ or more child or transaction tables

The project will include the following elements for the chosen business.

$1.$ Introduction and Overview of the database

$2.$ Identify the business rules of this business as it applies to the data

$3.$ Create an Entity Relationship Diagram in crow$$s feet notation.

$4.$ Create a relational diagram using a $3$ column crow$$s feet diagram. Make sure you include all primary and foreign

keys and data types on all columns.

$5.$ Create a table in the lab document to identify the primary key for each entity.

$6.$ Explain and apply the integrity rules for each entity.

$7.$ Use a table in the lab document to define the relationships between each entity. Make sure you list the

cardinality of the relationships.

$8.$ Create the database in SQLite.

$9.$ Show SQL statements for each table creation.

$10.$ Highlight in your SQL statements where you assigned keys to each table, or show the SQL statements that assign

keys to each table.

$11.$ Highlight in your SQL statements where you establish any foreign keys, or show the SQL statements for each

foreign key establishment.

$12.$ Populate the database with at least $5$ records in each table, and show the SQL statements used to populate the

database.