Deliverables

$1.$ Report $(15$ Marks$)$

o Business Background: Provide a summary of the business, including its history, operations, and the products or services it offers.

o Database Requirements: Detail the requirements of the database, identifying the following elements:

$$ Entities and Attributes: List all entities $($e$.$g$.,$ Customer, Product, Order$)$ and their corresponding attributes $($e$.$g$.,$ CustomerID, FirstName, ProductName$).$

$$ Unique Identifiers: Specify unique identifiers for each entity $($e$.$g$.,$ CustomerID for Customer$).$

$$ Functional Dependencies: Describe the functional dependencies within the database.

$$ Primary and Foreign Keys: Identify primary and foreign keys for each entity.

$$ Relationships: Explain the relationships between entities $($e$.$g$.,$ One$-$to$-$Many, Many$-$to$-$Many$).$

$2.$ Screenshots $(15$ Marks$)$

o Database Schema Design: Provide screenshots of the schema design in MySQL Workbench.

o Database Tables: Show all tables created in the database, including their structures. Populate the database with sample data and include screenshots of any queries created and their results.

$3.$ ER Diagram $(10$ Marks$)$

Use MySQL Workbench to create an Entity Relationship diagram for the database.

o Show all entities, attributes, primary keys $($PK$),$ foreign keys $($FK$),$ and relationships.

o Indicate cardinalities $($e$.$g$.,$ One$-$to$-$Many, Many$-$to$-$One$)$ and other constraints.