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

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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

You are a junior analyst at Titan Capital, a private equity firm looking to purchase and merge two cybersecurity firms. Your managing partner, Mitchell, is asking for your assessment of which two...

Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...

The problem As a Database Administrator (DBA), you have been provided with the following account detailing the access security criteria for a SQL database system. The database consists of three...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

16. The external model yields some advantages such as ______________ a. use of the database subsets to make application program development much simpler. b. use of the database subsets to make...

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...

Suppose that R(A, B, C) is a relational schema with functional dependencies F = {A, B C, C B}. (i) Is this schema in 3NF? Explain. [2 marks] (ii) Is this schema in BCNF? Explain. [2 marks] (b)...

llustrate different ways of connecting these components together to span a range of performance requirements. [10 marks] For each of the performance categories that you identify state today's typical...

2,4,5 only thank yoy 1) Set up an integral for the surface area generated by rotating with respect to the x-axis, 0 y 2. 2) Set up an integral for the length of the curvey-In(cos(x)).0sxs 3) Evaluate...

Steve and his cousin Alex started an equal partnership business, Euca Sanitizers, motivated by the increase in the recent demand for hand sanitizers during the COVID-19 pandemic. Steve lives in...

19. JERRY: In spite of the great strides technology has made in this country, poverty remains a terrible problem. Why, some people earn less than $10,000 per year. Th e government should do something...

(c): Find the complete integral of p'sec x + Z'q? cosec'y = z

The correlation of the random variables X and Y if each of them takes only 3 values (1,2,3) with the following probabilities : 1 2 3 1 0 1/6 1/6 y 2 1/6 0 1/6 0 1/6 3 1/6 1/6 0 Select one: O a none...

XYZ Products, Selected Accounts from the Adjusted Trial Balance dated December 31, 2018 (for its year ended December 31, 2018). Sales $385,000 Sales returns 12,000 Inventory 32,692 Purchase discounts...

Case Challenges 1 . 2 . Should Southwest partner with other carriers to provide expanded customer service? Why or why not? 3 . Major airlines have collected large sums from fees for checked bags. Is...

In the TAL Distributors database shown in Figure 2-1, the Rep table contains four rows and the Customer table contains 12 rows. How many rows would be contained in the Cartesian product of these two...

Write the SQL commands to obtain the following information from the system catalog: a. List every table that you created. b. List every field in the Customer table and its associated data type. c....

An attribute is a characteristic or property of an entity. If person is an entity, would the same attributes be used to describe a person in different databases that store medical, student, and...

20. In what ways are hurt feelings similar to physical pain?

1. Why would it be harder to deprive someone of just NREM sleep than just REM sleep?

16. Do memories become improved during sleep by strengthening or weakening synapses?