5.13. DataBase Consider the relation CLASS(Course#, Univ_Section#, Instructor_na

Question

5.13. DataBase Consider the relation CLASS(Course#, Univ_Section#, Instructor_name, Semester, Building_code, Room#, Time_period, Weekdays, Credit_hours). This represents classes taught in a university, with unique Univ_section#s. Identify what you think should be various candidate keys, and write in your own words the conditions or assumptions under which each candidate key would be valid.

AIRPORT Airport code Name City State FLIGHT Flight number Airline Weekdays FLIGHT LEG Right number Leg number Departure airport code Scheduled departure time Arrival airport code Scheduled arrival time LEG INSTANCE Flight number Leg number Date Number of available seats Airplane id Departure airport code Departure time Arrival airport code Arrival time FARE Right number Fare code Amount Restrictions AIRPLANE TYPE Airplane type name Max seats Company CAN LAND Airplane type name Airport code AIRPLANE Airplane d Total number of seats Airplane type SEAT RESERVATION Light numbor numbord Seat number Customer nane Customer phone Figure 5.8 The AIRLINE relational database schema.

Explanation / Answer

Table airport = Airport_code

Flight = Flight_number

Flight_leg = {Flight_number},{leg_number}

leg_instance = {flight_nmuber,date}, {leg_number,date}

fare= {flight_number}{fare_code}

airplane_type = {airplane_type_name}

can_land = {airplane_type_name,Airport_code}

Airplane = {Airplane_id}

seat_reservation = {Flight_number,date} {seat_number,date}

Related Questions

Navigate

• Browse (All)
• Browse 5
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.