Specify the queries and updates of 6.17 and 5.11, which refer to the AIRLINE database (see Figure 5.8), in SQL. a. Design a relational database schema for your database application. b. Declare your...

Specify the queries and updates of 6.17 and 5.11, which refer to the

AIRLINE database (see Figure 5.8), in SQL.

a. Design a relational database schema for your database application.

b. Declare your relations, using the SQL DDL.

e. Specify a number of queries in SQL that are needed by your database application.

d. Based on your expected use of the database, choose some attributes that

should have indexes specified on them.

e. Implement your database, if you have a DBMS that supports SQL.