Reference no: EM13949630
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.
|
Analyse the latest financial statements
: Analyse the latest financial statements of a mining company ‘Mining Projects Group Limited, MPG' and come up with a conclusion with supporting data or information whether to invest in the company or not.
|
|
Determine the equivalence ratio
: 1. Octane (C8H18) enters an engine and burns with air to give products with the dry molar analysis of CO2, 10.5%; CO, 5.8%; CH4, 0.9%; H2, 2.6%; O2, 0.3%; N2, 79.9%. Determine the equivalence ratio.
|
|
Distribution transformer
: The data in the table attached were obtained when open circuit and short circuit tests were performed on a single phase 50kVa, 2400:240 V, 60 Hz distribution transformer Please show all steps and explanations
|
|
Develop plots of the air-fuel ratio
: Pentane (C5H12) burns with air so that a fraction x of the carbon is converted to CO2. The remaining carbon appears as CO. There is no free O2 in the products. Develop plots of the air-fuel ratio and the percent of theoretical air versus x, for x ran..
|
|
What airplane models are stored in a particular hangar
: We require a data base for a small airport. The data base should track airplanes, pilots, hangars, airplane types, mechanics and airplane owners.
|
|
What means employee length of experience with their managers
: What is the difference between the means of employees' length of experience with their managers and their decisions of staying or leaving their current job?
|
|
Determine the balanced reaction equation
: Determine the balanced reaction equation. For the CO and SO2, determine the amount, in kmol per 106 kmol of combustion products (that is, the amount in parts per million).
|
|
Innovative technology products and services
: Apple Inc. (Apple) is a worldwide provider of innovative technology products and services. Apple's products and services include iPhone®, iPad®, Mac®, iPod®, Apple TV®, a portfolio of consumer and professional software applications, the iOS and OS..
|
|
Calculate the change in a batchs profits from the beginning
: Assume that the batch productivity statistics are met by the end of the year. Calculate the change in a batch's profits from the beginning of the year to the end attributable to changes in materials and labor productivity.
|