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

Question $2$:

A course described by the course$\_$code, course$\_$title, credit$\_$Hrs may or may not have many pre$-$requisites. A course may or may not be a pre$-$requisite of many courses.

Acourse has many course$-$sections. A course$-$section is described as sectionId$,$ max$\_$enrollment, A section is always identified by the COURSE entity and the sectionID$.$ Draw an ER diagram. $($edited$)$

Question $3$

Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course:

STUDENT$($SSN$,$ Name, Major, Bdate$)$

COURSE$($Course#$,$ Cname, Dept$)$

ENROLL$($SSN$,$ Course#$,$ Quarter, Grade$)$

BOOK$\_$ADOPTION$($Course#$,$ Quarter, Book$\_$ISBN$)$ TEXT$($Book$\_$ISBN, Book$\_$Title, Publisher, Author$)$ Draw a relational schema diagram specifying the foreign keys for this schema.

Question $4$:

Consider any regular entity of your project. Follow the rules for mapping a regular entity into relation. Write the SQL code for creating the table for the same relation.