solution1 - Database Systems Instructor: Hao-Hua Chu Fall...

Download Document
Showing pages : 1 - 2 of 4
This preview has blurred sections. Sign up to view the full version! View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Database Systems Instructor: Hao-Hua Chu Fall Semester, 2007 Homework 1: ER Diagram Questions 1. (Textbook Q2.6) Computer Sciences Department frequent flies have been complaining to Dane County Airport officials about the poor organization at the airport. As a result, the officials decided that all information related to the airport should be organized using a DBMS, and you have been hired to design the database. Your first task is to organize the information about all the airplanes stationed and maintained at the airport. The relevant information is as follows: □ Every airplane has a registration number, and each airplane is of a specific model. □ The airport accommodates a number of airplane models, and each model is identified by a model number (e.g., DC-10) and has a capacity and a weight. □ A number of technicians work at the airport. You need to store the name, SSN, address, phone number, and salary of each technician. □ Each technician is an expert on one or more plane models(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 membership number of each employee....
View Full Document

Create a FREE account now to get started. Log In

The email address you entered is not valid. The email address you provided is already in use.
Your username must be at least 5 characters. Your username must consist of only alphanumeric characters. Your username must contain at least one letter. Your username contains inappropriate language. Another user has already claimed this username.
Your password must be at least 6 characters in length.
{[ $select.selected.label ]} Please select a valid school.
By creating an account you agree to our Privacy Policy, Terms of Use, and Honor Code.
Create my FREE account Processing...
Sign Up with Facebook

We will never post anything without your permission.

Already on Course Hero? Log In