loading..
Русский    English
09:22

Airport

Database schema consists of 4 tables:

  1. Company (ID_comp, name)
  2. Trip (trip_no, id_comp, plane, town_from, town_to, time_out, time_in)
  3. Passenger (ID_psg, name)
  4. Pass_in_trip (trip_no, date, ID_psg, place)

Схема данных Аэрофлот

Company table has ID and name of the company, which transports passengers.

Trip table has information about trips: trip number, company ID, plane type, departure city, arrival city, departure time, and arrival time.

The Passenger table has passenger's ID and passenger's name.

Pass_in_trip table has information about the flights: trip number, departure date (day), passenger's ID and his place during the flight. We should note that,

  • Any trip is being accomplished every day; duration of a flight is less than a calendar-day (24 hours);
  • Time and date are considered comparatively one time zone;
  • The departure time and the arrival time are given to within a minute;
  • There can be the passengers bearing the same names (for example, Bruce Willis);
  • The place during the flight is a number followed by a letter; the number defines the row number, the letter (a - d) – the place in the row (from the left to the right) in the alphabetical order;
  • Relationships and restrictions are shown in the data schema.
Bookmark and Share
Tags
aggregate functions Airport ALL AND AS keyword ASCII AVG Battles Bezhaev Bismarck C.J.Date calculated columns Cartesian product CASE cast CHAR CHARINDEX Chebykin check constraint classes COALESCE common table expressions comparison predicates Computer firm CONSTRAINT CONVERT correlated subqueries COUNT CROSS APPLY CTE data type conversion data types database schema date/time functions DATEADD DATEDIFF DATENAME DATEPART DATETIME DDL DEFAULT DEFAULT VALUES DELETE DISTINCT DML duplicates equi-join EXCEPT exercise (-2) exercise 19 More tags
The book was updated
month ago
redlands aged care
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.
Rambler's Top100