1) [50 pts] Map the following enhanced entity-relationship diagram into a relational database schema. Please
state any assumptions that you have made. Do not forget to use arrows for foreign key – primary key
references.
Student ID: Student Name:
Asst.Prof.Dr. Mustafa AĞAOĞLU CSE3055 – F’17|HW#2
2/2
2) [50 pts] Map the following entity-relationship diagram into a relational database schema. Please state any
assumptions that you have made. Do not forget to use arrows for foreign key – primary key references.