[Solved] Project Phase 2 relational schema diagram

Use the EER diagram provided by your instructor (hard copy, given in class) as the formal requirement specification of this project and convert it into a relational schema diagram using the mapping steps explained in class.

Your task:

• Design relations (tables). Each relation (table) should contain the following information: name, attributes, and, primary key.
• Each attribute should have appropriate data type.
• Foreign keys must be specified if there are any.
• Referential integrity constraints must be specified if there are any.

Using Oracle Data Modeler:

• You must use Oracle Data modeler to create a relational model (Note here: not logical model).
• Export your model to DDL file (say project.sql). If you see any errors in the DDL file, fix the model and generate new sql code until no errors are left.