Part $1$:

Convert your $($E$)$ER conceptual schema from Assignment $1$ into relational database schema. Be certain to indicate primary

keys and referential integrity constraints

Please follow the relation schema format discussed in Lecture $5$: ER to Relational mapping.

Example: Student Taking Course

Now, mapping the above ER to relational schema would look like the following. Primary Keys and Foreign Keys are

marked as shown.

Student$($SID: Integer, name: String$)$

Takes $($SID: Integer, CID: Integer$)$

Course$($CID: Integer, name: String, Semester: String$)$

Concepture schema of assignment $1$