Read the Introduction, ER$,$ Crow's Feet, Relational Model Lecture Notes and study Database

Fundamentals $($Book Chapter$)$ Figure $13\mathrm{.}12$ Figure $13\mathrm{.}13$ example $($ignore the normalization

process for now$).$ All materials are posted on the Course Content page on Blackboard.

Homework #$1$

Convert the following ER diagrams to Relational Schema $($express the schema in a format as

shown in Figure $13\mathrm{.}13$ example given in the Book Chapter $-$ Database Fundamentals$)-$ Note,

you can rename attributes when there are name conflicts $($i$.$e$.,$ whenever you find that in a

table there are attributes that have the same name, you must change their names so that each

attribute has a distinct name in the table$).$

Q$1$

Q$2.$

Q$3.$ For this conversion, you are not allowed to create a separate table for relationship $\text{'}S\text{'}$:

Q$4.$ Figure $3$ in Lecture Note: ER Model

Q$\mathrm{.}5.$ Figure $4$ in Lecture note: ER Model