Indian government had decided that all information related to the airport should be organized using automation, and you have been hired to design the system. For this the relevant information is as follows:
1. Every airplane has a registration number, and each airplane is of a specific model.
2. The airport accommodates a number of airplanes models, and each model is identified by a model number and has a capacity and a weight.
3. The number of technicians works at the airport. You need to store the name, SSN, address, phone number and a salary of each technician.
4. 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.
5. Traffic controllers must have an annual medical examination. For each traffic controller, you must store the date of the most recent exam.
6. All airport employees 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.
7. The airport has a number of tests that are used periodically to ensure that airplanes are still airworthy. Each test has a Indian Aviation Administration (IAA) test number, a name, and a maximum possible score.
8. The IAA requires the airport to keep track of each time a given airplane is tested by a given technician using a given test. Foe each testing event the information needed is the date, the number of hours the technicians spent doing the test, and the score the airplane received on the test.
- You are appointed to design International movie data base system. The system stores and manipulates information about movies, casts (actors or actresses), crews, studios, awards, cinemas, news, etc. The following gives the requirements for the IMDB.
a. IMDB records the information about each studio, such as studio name, year established, year closed (if applicable), country, etc The system records overall movie information, such as movie title, tagline, genre, year made, country, website, running time, language, colour, rating, showing start date, ranking, etc.
b. Tagline is a one-sentence description of a movie. Values of colour could be “True” or “False” for colour movie or black/white movie respectively. And Rating could be “G”, “PG”, “M”, “MA”, etc. Studios produce movies.
c. The genre describes the type of a movie, such as “comedy”, “drama”, “biography”, “action”, “thriller”, “horror”, “romance”, “war”, “animation”, “adventure”, etc. One movie may have more than one genre.You may record the people involved with the movies with their titles, family names, given names, genders, websites, emails, dates of birth, cities of birth, countries of birth, and other necessary information.
d. A casts is actor or actress in a movie. Crews are staff other than casts involved with a movie, such as “Director”. You should record each role’s name for casts. For example, “Actor of leading role”, “Actor of supporting role”, etc.
e. You should record each job title for crews. For example, “Director”, “Producer”, “Writer”, etc. You may assume a person only performs one role in a movie. IMDB records the name of each part in a movie, also records the job title for each crew in a movie. There are many movie awards around the world from different organization. The organization is recorded with name and country. Each organization holds one award ceremony in each year.
f.
You should record the award and nominations with title,
category, etc. Award titles could be classified as to two categories: for
person (such as “Best Actor of leading role”, “Best Director”) or for movie
“Best movie”, etc. There will be many nominations for an award in a given year,
but only one winner for the award in that year. An award may been won many
times, or may have never been awarded (or nominated)
