Question $1$:

Create an ER diagram for an online retail store.

The following are the data entities like "Customer,"

"Product," "Order," and "Payment."

Part a:

A customer is described by CustomerID$($identifier$),$ Customer Name, which is composed of FName, LName. several telephone numbers, BasicSalary, Housing Allowance which is $15\%$ of BasicSalary.

Include attributes for other entities "Product," "Order," and "Payment." based on your own understanding.

Part b:

The following are the relationships such as

"Customer places zero or many Orders"

An Order contains many Products. One Product is included in many Orders. The quantity of each product in an order is also recorded.

"Every Product belongs to one Category,". One Category has one or many products

"One Payment method used for one Order. Every order has one payment

Draw all data entities "Customer," "Product," "Order," and "Payment."

Show the relationships between them.

Part C:

Include cardinalities and participation. Solve parts A$,$ B$,$ and $C.$