Question: Create tables according to the mapping. For this part, submit a description of the tables created. Add at least five records. Submit a copy

Create tables according to the mapping. For this part, submit a description of the tables created. Add at least five records. Submit a copy of all the records inserted. Write and answer some (at least five) "reasonable" queries for your database. When I say reasonable queries - I mean 3-4 table joins to use most of the tables or group of tables in your database. You should not have tables that are of no use. For this part, first, write the queries in English - that is, telling me what you are finding in the queries. Then, present the query and finally present the output of the query (as you do for your homework assignments). Note this part is not done in actual Oracle student database.

Step by Step Solution

★★★★★

3.44 Rating (138 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answer The code is as follow Table Wars CREATE TABLE Wars warid INT PRIMARY KEY AUTOIN... View full answer

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!

A steam turbine operates at steady-state with 1.8 MPa and 350C steam at its inlet and wet- steam (vapor-liquid mixture, x = 0.90) at 95C at its exit. The mass flow rate of the steam is 38 kg/s, and...

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...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using...

(Stock Dividends and Splits) The directors of Merchant Corporation are considering the issuance of a stock dividend. They have asked you to discuss the proposed action by answering the following...

6.60 Refer to Exercise 6.59. What should be the mean diameter of the shafts produced to minimize the fraction not meeting specifications?

=+f) Are any six points in a row increasing (or decreasing)?

Refer to the pricing waterfall chart in Exhibit 6-4. Required (a) What circumstances result in firms often failing to be aware of all of the discounts and allowances granted on a customer order? (b)...

There are N holes arranged in a row in the top of an old table. We want to fix the table by covering the holes with two boards. For technical reasons, the boards need to be of the same length.

Brock Company is a merchandiser that prepared the statement of cash flows and income statement provided below: Required: Assume that you have been asked to teach a workshop to the employees within...

___blank approaches to organizational change refer to managerial actions that attempt to improve effectiveness by introducing change through formal policies and procedures. Multiple Choice Process...

How can a stakeholder play a significant role in providing support for the strategic planning process? Explain

1 Strategic Analysis , choice and implementation. Please review the the forgoing chapter in the studying strategy resource for the week. What would you judge the analysis, choice and implementation...

Public Relations play a crucial role in electoral campaigns. We propose that you, through the information provided in the study guide and external data, manage a Public Relations Project for an...

Choose an Emergency Support Function (ESF) of the National Response Framework. Describe the type of response scenario where the ESF would be utilized. Explain why....

The system below is used to raise heavy objects, via a hydraulic cylinder AB, and a roller at D. The roller at D is in contact with the ground and connected to member DCB via a frictionless pin....

these are case studies questions in my text book. You will read up case 6 and answer case 7 and 8. Thank you expert. Do a job this time. Donot just eat my money, do some serious work trarlle round...

A Alkynes can be made by dehydrohalogenation of vinylic halides in a reaction that is essentially an E2 process. In studying the stereochemistry of this elimination, it was found that...

Identify and explain the types of contracts that may violate a statute, and distinguish between the two types of licensing statutes.

Shell Oil Company leased to Flying Tiger Line a gasoline tank truck with a movable ladder for refueling certain types of aircraft. Under the terms of the lease, Flying Tiger was to maintain the...

Identify and discuss the situations involving voidable mistakes.

Consider the market represented in Figure 5P-5. a. Draw the consumer surplus and producer surplus if the market is functioning at the equilibrium price and quantity. Compute the total surplus if the...

Consider the market represented in Figure 5P-4. a. Calculate total surplus when supply is S1. b. Calculate total surplus when supply increases to S2.

Answer the following questions based on Tables 5P-1 and 5P-2. a. What is the quantity demanded at $10? What is the quantity supplied at $10? b. What is the quantity demanded at $25? What is the...