Detailed Question: Develop a relational schema based on the E-R diagram?
Problem Statement-
For this second assignment, you are to develop a relational schema based on the conceptual data model (ER diagram). Your relations should be normalized to the third Normal form. Be sure to underline each (simple or composite) primary key and show an arrow (referential integrity constraint) from each foreign key to its corresponding primary key. You do not need to underline each foreign key with a dashed underline.
![1077_Diagram.png](https://secure.tutorsglobe.com/CMSImages/1077_Diagram.png)