Reference no: EM13925335
Airport Management Information System
In this project, you are assigned to design, organize and implement a RDBMS for Ercan Airport Management that will store, manipulate and retrieve all airport related information. The database you will design will organize the information about all the airplanes stationed and maintained at the airport as well as:
The DB should store detailed information about the airplanes (i.e. plane_no, model_no, capacity etc.),
The location airplanes are located when not flying (i.e. hangar_no, location etc.) should also be stored. However, airplanes are not staying in hangars forever, your database should store IN and OUT dates/times.
The airport has a number of tests that are used periodically to ensure that airplanes are still airworthy.
It is also required to keep track of each time a given airplane is tested by a given technician using a given test. For each testing event, the information needed is the date, the number of hours the technician spent doing the test, and the score the airplane received on the test.
There are different types of workers in the airport such as traffic controller, airport employees and technicians (testing and repairing aircrafts).
Each technician is an expert on one or more plane model(s), and his or her expertise may overlap with that of other technicians. This information about technicians must also be recorded.
Traffic controllers must have an annual medical examination. For each traffic controller, you must store the date of the most recent exam.
All airport employees (including technicians) belong to a union. You must store the union membership number of each employee. You can assume that each employee is uniquely identified by a social security number.
A brief description and assumptions about tables and relations,
- ER Diagram (your design should contain at least 8 tables),
- Relational Data Model,
- Data Definition Language Details (DDL), including all necessary constraints,
- Data Manipulation Language (DML),
- Normalization Steps (upto 3NF),
- 15 queries retrieving statistical information to help management (use the functions/methods you learned, such as join, subquery, group by, to_char etc.)
These are the minimal requirements which means they have to be implemented, but implementing only the requirements that is mentioned above will not be enough to get full mark. You should extend this design and create a real-life database using MySQL or any other database program.
|
Did you agree with the defendants or the plaintiff
: How does the biblical worldview bear on the answer to the question(s) before the court?
|
|
How much turnover is require in order to achieve basis point
: How much value-added should it achieve with 100 percent annual turnover? How much turnover is required in order to achieve 100 basis points of value added?
|
|
Explain with a graph how sml is different from cml
: Explain with a graph how SML is different from CML. Why CAPM equation might be more relevant than other equations when calculating required rate of return.
|
|
Suppose the government imposes tax cuts
: Suppose the government imposes tax cuts for 95% of all households. How does this affect AT&T?In the past few years, the government has had an important role in "bailing out" certain industries. This is a type of government spending. How was your firm..
|
|
Organize and implement rdbms for ercan airport management
: design, organize and implement a RDBMS for Ercan Airport Management that will store, manipulate and retrieve all airport related information. The database you will design will organize the information about all the airplanes stationed and maintain..
|
|
The individuals who apply to teach for america
: The individuals who apply to Teach for America aren't necessarily looking for a career in education. Although 85 percent of recruits finish their two-year commitment, only 36 percent are still teachers two years later.9.135 Goldstein, "Does Teach for..
|
|
Why does high risk aversion lead to quick trading
: How would the presence of memory effects in market impact change the trade optimization results displayed in Fig. 16.5? In Fig. 16.5, why does high risk aversion lead to quick trading?
|
|
Debt reduction should also reduce the bankruptcy costs
: Teresina Company has debt/assets ratio 60%, which is too high and it should be at 55% to be optimal. This debt reduction should also reduce the bankruptcy costs by $25 million. At present, Teresina has 6 million shares of common stock selling at $45 ..
|
|
Manage an it project or a traditional project
: Do you think it's harder to manage an IT project or a traditional project, such as building construction? Justify your response. Please ensure response is 1-2 paragraphs in length.
|