Use your ERD (the attached picture) to define the table structures in the database using SQL DDL
Question:
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.
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last