Problem Description

The ER diagram shown in the following picture mostly follows the description of data in the previous assignment, with one extra specification that "When a listed property is sold, it is sold by a realtor that may or may not be same as the listing realtor".

Your Tasks:

First, translate the given ER diagram to its equivalent relational conceptual schema.
Clearly show the relations, the attributes, the primary keys and the foreign keys if there are any in the shcema. Note that the names of the relations and attributes don't need to be the same as the names used in the ER diagram. You can choose your own names as long as they are meaningful, easy to understand and not ambiguous.

Then, realize the relational conceptual schema with its equivalent physical schema.
Write the SQL statements that can actually create these relations/tables in Oracle database system. Choose reasonable data types for the attributes/columns, and specify at least all the primary key and foreign key constraints.

How to Submit

Make your answer precise and concise. Make your documentation easily understandable.

You can submit your assignment solution using one of the following two ways:

• Submit a hard copy (in or outside the lecture/lab time) before the due date/time.
• Login to your VIU Learn account, find the CSCI 370 course page, click on the "Assessment" drop-down menu, click on the "Assignments" item, then click on the folder named "A2". Then you can click on the "Add a File" button to browse and upload your solution file(s).