Purchase Solution

Create a Query to Produce an Output

Not what you're looking for?

Ask Custom Question

Create a query to produce the output shown in the figure below. The output, derived from the CHARTER and MODEL tables, is limited to February 6, 2004. (Hint: The JOIN passes through another table. Note that the "connection" between CHARTER and MODEL requires the existence of AIRCRAFT, because the CHARTER table does not contain a foreign key to MODEL. However, CHARTER does contain AC_NUMBER, a foreign key to AIRCRAFT, which contains a foreign key to MODEL).

Refer to http://www.google.com/search?hl=en&q=chapter+7+introduction+to+structured+query+language.

Please see the attachment for the full question.

Attachments
Purchase this Solution
Solution Summary

The response provides guidelines on creating a query to produce an output derived from a number of variables.

Purchase this Solution
Free BrainMass Quizzes
Javscript Basics

Quiz on basics of javascript programming language.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

View More Free Quizzes
Related BrainMass Solutions

  • Modifiy SQL statement for aircraft fuel

    Use a similar technique on joined tables to produce the "gallons per hour" output shown in the figure below. (Note that 67.2 gallons/1.5 hours produces 44.8 gallons per hour.)

  • SQLite - Grouping Records and Aggregate functions

    Create a query that uses a temporary value called OrderValue to hold the total value of each order for A1.

  • SQL Server Database

    Query 8 (SELECT SUBQUERY): Write a SELECT query that utilizes a SUBQUERY to determine if the EEO-Classification for an employee is invalid. This means that you need to use the NOT EXIST for the SUBQUERY.

  • data manipulation capabilities

    An example of a DDL trigger that prevents the dropping of a table is as shown: CREATE TRIGGER OnDropTable ON DATABASE FOR DROP_TABLE AS RAISERROR ('No drops allowed', 10, 1) ROLLBACK DML with Output SQL Server 2005 introduces the OUTPUT clause

  • application that uses objects to query and update a data source

    An application that uses objects to query and update a data source is modeled.

  • SQL script to sort numbers across columns

    Another query is provided that makes usage of this user defined function to produce an extra 5th column with sorted row results. The scripts are made in such a way that adding 5th, 6th, etc column should be an easy task.

  • Calculating Occurrences: Java Programming

    237118 Calculating Occurrences: Java Programming Need some assistance modifying attached code to meet/produce the following requirements/output: Write a program that reads numbers from the keyboard into an array of type int[].

  • Creating Queries from Woodcraft Database

    Research one new feature that you haven't studied as it relates to query generation, and show how you could use that feature to create a useful query.

  • Writing SQL Queries Using a Database and Tables

    ) - Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. (Use Emp_age to restrict data.) - Write a SQL query that uses UNION of the two tables to produce a combined result set.

View More Related Solutions