For this assignment, you are required to design a database for a small to medium$-$sized business in your community that would benefit from having a structured database system. Follow the steps below to complete the assignment:

Step $1$: Identify a Business

Find a small to medium$-$sized business in your community that you believe would benefit from having a database. Examples of such businesses could include a bakery, bookstore, gym, local retail shop etc.

Step $2$: Determine Database Requirements

Meet with the business owner or manager to understand their operations and data management needs. Identify the requirements for the database, focusing on 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$).$

Step $3$: Design and Create the Database

Using the requirements gathered, design the database and create it using MySQL$.$

Deliverables

Report $(15$ Marks$)$

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

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$)$

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

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.

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

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