Find capacity of a particular airplane type

Assignment Help Data Structure & Algorithms
Reference no: EM1380274

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.
Consider the entities and their attributes. You should 1st 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:

Question1. What is the capacity of a particular airplane type?
Question2. What is the weight of a particular airplane?
Question3. Which type of airplanes can a particular pilot fly?
Question4. What airplane models are stored in a particular hangar?
Question5. Which hangar is a particular airplane stored in?
Question6. List all pilots that can fly a particular airplane.
Question7. List all the mechanics that can service a particular airplane.
Question8. List all mechanics that can service a particular airplane type.

 

Reference no: EM1380274

Questions Cloud

Professional codes of ethics : Select one of the Professional Codes of Ethics associated with IT. If you were to complete a assignment related to securing the connectivity in your firm and its business partners.
Create the entity relationship diagram : Create the entity relationship diagram for your project database based on the initial data requirements.
Analyzing the use of database in an organization : Examine the use of databases in your company. Include what database applications are used. Conclude through proposing improvements.
Describe specific steps in the hiv life cycle : How could these three cell types be clearly and simply distinguished from each other in an experimental laboratory and how and where do these different cell types differentiate to their mature functional characteristics?
Find capacity of a particular airplane type : Consider the entities and their attributes. You should 1st determine what entities want to track. Next determine what attributes are required for each entity, and what relations exist between these entities.
Design adatabase to keep track of all students at university : Discuss how you would design a database to keep track of all students at a university. Explain tables, Primary Keys, Foreign Keys, relationships, attributes, Candidate Keys.
Database design process : A college course may have one or more scheduled sections, or may not have a scheduled section. Attributes of COURSE include Course_ID, Course_Name, and Units.
Question about trigger : What are triggers used for, and why are they important in database systems? Give an example of a situation where a trigger would be appropriate.
Test the database management system functionality : In a report that less than half of all companies validate the in their databases and test database management system's functionality. Explain your answer.

Reviews

Write a Review

 

Data Structure & Algorithms Questions & Answers

  Design a divide-and-conquer algorithm

Design a divide-and-conquer algorithm for the Motif Finding problem and estimate its running time. Have you improved the running time of the exhaustive search algorithm?

  Sketch flowchart for logic of program to enter three values

Sketch a flowchart or write psuedocode to represent logic of a program that alllows the user to enter three values .

  Describe why algorithm runs in on time

Assume you have the array A of n items, and you want to find k items in A closest to the median of A. Describe why your algorithm runs in O(n) time.

  Computing minimal length of key-average cracking time given

If Encrypt-It-Rite would like to increase average cracking time to at least 100 years, determine the minimal length of the key?

  Determining public keys for other party in sending message

Determine correct public keys for other party, and assuming that Eve can intercept any messages.

  Data structures and algorithm design

Data Structures and Algorithm Design

  Creating erd with primary, foreign keys and main attributes

A very small college wishes to keep track of history of all administrative appointments, The college chancellor may wish to know how many deans worked in college of business between January 1, 1960 and January 1 2008

  Water resources engineering

The current practice of a particular part of water resources engineering is supported through a variety of commercial software. Pick a specific domain within water resources engineering.

  Describe ambiguity in proposed algorithm

Describe the distinction between an ambiguity in a proposed algorithm and an ambiguity in the representation of an algorithm. Describe how the use of primitives helps remove ambiguities in an algorithm's representation.

  Implement an open hash table

In this programming assignment you will implement an open hash table and compare the performance of four hash functions using various prime table sizes.

  Create an algorithm to produce list of customers

Create an algorithm to produce list of customers from Glad Rags Clothing Company's customer master file. Each record on customer master file contains the customer's number

  Threat model to describe risk of attack vector

Construct a simple threat model that describes the risk this represents: attacker(s), attack vector, vulnerability, assets, and likelihood of occurrence, likely impact, and plausible mitigations.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd