Purchase Solution

SQL Queries - What is the capacity of a particular airplane type?

Not what you're looking for?

Ask Custom Question

A small airport:
We require a data base for a small airport. The data base should track airplanes,
pilots, hangars, airplane types, mechanics and airplane owners.
The airport maintains the usual data,
on airplanes: registration number,
on airplane types: model, capacity and weight ,
on hangars: hanger number, location and capacity,
on pilots: name, license nr, address,
on mechanics: name, phone nr, address and employee ID,
on airplanes owners: name, address and phone nr.
Think about the entities and their attributes. You should first determine what entities want to track. Next determine what attributes are needed for each entity, and what relations exist between these entities. You should draw an E-R diagram to show these relations. Be sure to indicate all keys. As a final step write the queries in SQL. You will be also be expected to turn in your E-R diagram, SQL code and a test of your database with some test data that you may make up.
Also be sure to make reasonable assumptions, you will be graded on your design as
well as other factors.

Queries:

1. What is the capacity of a particular airplane type?
2. What is the weight of a particular airplane?
3. Which type of airplanes can a particular pilot fly?
4. What airplane models are stored in a particular hangar?
5. Which hangar is a particular airplane stored in?
6. List all pilots that can fly a particular airplane.
7. List all the mechanics that can service a particular airplane.
8. List all mechanics that can service a particular airplane type.

Purchase this Solution
Solution Summary

The solution examines the capacity of a particular airplane type for SQL queries.

Solution Preview

Example SQL Queries:

1. What is the capacity of a particular airplane type?

SELECT capacity FROM AirplaneType WHERE ModelNr = "AT001";

2. What is the weight of a particular airplane?

SELECT weight FROM AirplaneTypes WHERE AirplaneTypes.ModelNr = Airplanes.ModelNr AND RegistrationNumber = "A001";

3. Which type of airplanes can a particular ...

Purchase this Solution
Free BrainMass Quizzes
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.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Javscript Basics

Quiz on basics of javascript programming language.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

View More Free Quizzes
Related BrainMass Solutions

  • SQL queries

    (b) Find the average amount of money that it has taken to do maintenance on each different model of jumbo jet (defined to be any airplane model whose capacity is at least 150). (c) Double the capacity of each DC-10 airplane.

  • Union and Union All Operations in SQL

    What are some applications of these operations? In SQL the UNION operator combines the results of two SQL queries into a single table of all matching rows. The two queries must have matching fields and data types in order to join them.

  • Database, table and query design affect database performance

    Try to make the database do the work. Try to write SQL queries as stored procedure. They are precompiled and efficient way of writing SQL queries. It is easy to write a bad sql query and difficult to write one.

  • Designing a database

    What it does is display the communications sent from the Query Analyzer (acting as a SQL Server client) to SQL Server. This is the same type of information that is captured by the SQL Server 2000 Profiler, described later in this article.

  • Monitoring the Performance of SQL Server

    What it does is display the communications sent from the Query Analyzer (acting as a SQL Server client) to SQL Server. This is the same type of information that is captured by the SQL Server 2000 Profiler, described later in this article.

  • Data Manipulation and Monitoring

    What it does is display the communications sent from the Query Analyzer (acting as a SQL Server client) to SQL Server. This is the same type of information that is captured by the SQL Server 2000 Profiler, described later in this article.

  • SQL server XML to insert and query Products

    545309 SQL server XML - Table with XML field and XML data. Updates and Queries using XML Path. Create a table of XML documents with a type of XML. Use a primary key (you can't use an XML type) so add a field of type INT that is an identity.

  • Monitoring the performance of SQL Server

    What it does is display the communications sent from the Query Analyzer (acting as a SQL Server client) to SQL Server. This is the same type of information that is captured by the SQL Server 2000 Profiler, described later in this article.

  • data manipulation capabilities

    The argument in this case was a constant value of type FLOAT. In SQL Server 2005, an argument can be specified using an expression or a query, the only condition being that both should result in a value that is of the correct type.

View More Related Solutions