Imagine, you are a database administrator working for a small e$-$commerce company that sells a variety of products online. The company wants to enhance its database system to better manage its inventory, orders, and customers.

Considering the four entities namely Product, Customer, Order, and Inventory. Define the relationships between these entities and identify key attributes for each entity.

Translate the above four identified entities and attributes into tables with appropriate primary and foreign keys.

Create an Entity$-$Relationship $($ER$)$ diagram that visually represents the structure of the e$-$commerce company's database system. Include all entities, relationships, attributes, and keys identified in parts $($a$)$ and $($b$).$ Clearly indicate cardinality and participation constraints. Ensure the ER diagram is properly labelled and easy to understand.

Explain two differences between conceptual and physical design in this scenario, highlighting their respective roles in database development and implementation.

You can create Entity$-$Relationship $($ER$)$ diagram using any online ER Diagramming tool. Refer to the list of ER diagramming tools provided below:

Lucidchart: Online diagram software for creating ER diagrams.

EdrawMax: Online tool for ER diagram design.

dbdiagram.io: Tool for visualizing database relationships.

Flowchart Maker: Online software with ER diagram capabilities.

Submission Instructions

Read the rubric on how you are going to be graded before you start to work on this assignment.

Be sure to copy images $($ER diagram$)$ and paste them directly into your document.