Create the relational diagram.Use the database shown in Figure P3.24

Create the relational diagram.


Use the database shown in Figure P3.24 to answer this Problem. ROBCOR is an aircraft charter company that supplies on-demand charter flight services using a fleet of four aircraft. Aircrafts are identified by a unique registration number. Therefore, the aircraft registration number is an appropriate primary key for the AIRCRAFT table.


Figure P3.24:

Database name: Ch03_AviaCo Table name: CHARTER OHAR TRP CHAR DATE CHAR PLOT CHAR COPLOT AC NUMEER CHAR DESTNATION CHAR D


The nulls in the CHARTER table€™s CHAR_COPILOT column indicate that a copilot is not required for some charter trips or for some aircraft. Federal Aviation Administration (FAA) rules require a copilot on jet aircraft and on aircraft having a gross take-off weight over 12,500 pounds. None of the aircraft in the AIRCRAFT table are governed by this requirement; however, some customers may require the presence of a copilot for insurance reasons. All charter trips are recorded in the CHARTER table.

Table name: PILOT EMP NUM PL UICENSE PIL_RATINGS PIL_MED_TYPE PIL_MED_DATE PL_PT135_DATE Database name: Ch03_AviaCo 101


ROBCOR is an aircraft charter company that supplies on-demand charter flight services, using a fleet of four aircraft. Aircraft are identified by a (unique) registration number. Therefore, the aircraft registration number is an appropriate primary key for the AIRCRAFT table.


The nulls in the CHARTER table€™s CHAR_COPILOT column indicate that a copilot is not necessarily required for some charter trips or for some aircraft. Federal Aviation Administration (FAA) rules require a copilot on jet aircraft and on aircraft having a gross take-off weight over 12,500 pounds. None of the aircraft in the AIRCRAFT table is governed by this requirement; however, some customers may require the presence of a copilot for insurance reasons. All charter trips are recorded in the CHARTER table.

Members

  • Access to 2 Million+ Textbook solutions
  • Ask any question from 24/7 available
    Tutors
$9.99
VIEW SOLUTION
OR

Non-Members

Get help from Computer science Tutors
Ask questions directly from Qualified Online Computer science Tutors .
Best for online homework instance.