Use your ERD (the attached picture) to define the table structures in the database using SQL DDL commands to build your schema. Search "Oracle Built-in Datatypes" to determine the correct datatypes for attributes. Examples can be found at the following link: Oracle Create Table Video Links to an external site. w3schools SQL Links to an external site. Be sure to have your Primary and Foreign Keys match your final ERD! Populate your tables with at least 3 rows of data each. Make up any real estate information you'd like. Optional Bonus worth 5 Extra Points: make at least 3 queries retrieving "useful" information from the database. At least one of these queries needs to include a JOIN. Explain what each of the queries does as well as showing the SQL statement that accomplishes it. 

 

Contractors Agreements PK con_id (int) H+ PK agr_number (int) con_name (varchar) FK con_id (int) con_address (varchar) con_description (varcar) con_phone (int) Buyer PK buyer_id (int) buyer_name (varchar) buyer_address (varchar) buyer_contact (int) buyer job (varchar) buyer_salary (float) buyer_account_num (int) buyer credit score (int) Agents PK agent_id agent_name (varchar) agent_address (varchar) agent_phone (int) Sales Properties + PK sale_id (int) ++ PK prop_id (int) FK buyer_id (int) FK prop_id (int) FK agent_id (int) Employee PK emp_code (int) emp_name (varchar) emp_address (varchar) emp_phone (int) emp_role (varchar) FK arch_id (int) FK agent_id prop_parc_num (varchhar) prop_address (varchar) prop_room_num (int) prop_sq_total (float) prop_purchase_date (date) Architecture Style PK arch_id (int) arch_name (varchar) arch_desc (varchar) prop_mrkt_value (float)