Bài tập ôn tập cơ sở dữ liệu SQL

Exercise 2

1. Create a new database called

‘Flight_Management’

2. Use SQL Query Analyzer to work with Flight_Management database and create a SQL

script file follow those steps:

1. Create tables and insert data as follows:

Flight

Column Name Data Type Length Allow Nulls

Aircraft_code char 5

Aircode char 2

Type varchar 10

Source varchar 15

Destination varchar 15

Category varchar 15

Dep_time varchar 15 x

Journey_hrs int 4 x

Flight_details

Column Name Data Type Length Allow Nulls

Aircraft_code char 5

Class_code char 2

Fare numeric 5

Seats numeric 5

Flight_days

Column Name Data Type Length Allow Nulls

Aircraft_code char 5

day_code int 4

insert the following data into tables

Flight table