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.
|
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.
|