Русский    English

Database «Airport» page 1

The 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)

The Company table contains IDs and names of the airlines transporting passengers. The Trip table contains information on the schedule of flights: trip (flight) number, company (airline) ID, plane type, departure city, destination city, departure time, and arrival time. The Passenger table holds IDs and names of the passengers. The Pass_in_trip table contains data on flight bookings: trip number, departure date (day), passenger ID and her seat (place) designation during the flight. It should be noted that

- scheduled flights are operated daily; the duration of any flight is less than 24 hours; town_from <> town_to;

- all time and date values are assumed to belong to the same time zone;

- departure and arrival times are specified with one minute precision;

- there can be several passengers bearing the same first name and surname (for example, Bruce Willis);

- the seat (place) designation consists of a number followed by a letter; the number stands for the row, while the letter (a – d) defines the seat position in the grid (from left to right, in alphabetical order;

- connections and constraints are shown in the database schema below.

Схема данных Корабли

Fig. Schema of database «Airport»

Next page

Bookmark and Share
Pages 1 2
Развернуть всё
Свернуть всё


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 DATEADD DATEDIFF DATENAME DATEPART DATETIME date_time functions DDL DEFAULT DEFAULT VALUES DELETE DISTINCT DML duplicates edge equi-join EXCEPT exercise (-2) More tags
The book was updated
month ago
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.