What are the primary keys and foreign keys and anything else that may need desig

Question

What are the primary keys and foreign keys and anything else that may need designated in SQL?

AIRCRAFT-table
AC_NUMBER
MOD_CODE
AC_TTAF
AC_TTEL
AC_TTER

CHARTER-table
CHAR_TRIP
CHAR_DATE
AC_NUMBER
CHAR_DESTINATION
CHAR_DISTANCE
CHAR_HOURS_FLOWN
CHAR_HOURS_WAIT
CHAR_FUEL_GALLONS
CHAR_OIL_QTS
CUS_CODE

CREW-table
CHAR_TRIP
EMP_NUM
CREW_JOB

CUSTOMER-table
CUS_CODE
CUS_LNAME
CUS_FNAME
CUS_INITIAL
CUS_AREACODE
CUS_PHONE
CUS_BALANCE

EARNEDRATING-table
EMP_NUM
RTG_CODE
EARNRTG_DATE

EMPLOYEE-table
EMP_NUM
EMP_TITLE
EMP_LNAME
EMP_FNAME
EMP_INITIAL
EMP_DOB
EMP_HIRE_DATE

MODEL-table
MOD_CODE
MOD_MANUFACTURER
MOD_NAME
MOD_SEATS
MOD_CHG_MILE

PILOT-table
EMP_NUM
PIL_LICENSE
PIL_RATINGS
PIL_MED_TYPE
PIL_MED_DATE
PIL_PT135_DATE

RATING-table
RTG_CODE
RTG_NAME

Explanation / Answer

AIRCRAFT-table
AC_NUMBER //Primary Key.
MOD_CODE //References Model table.
AC_TTAF
AC_TTEL
AC_TTER

CHARTER-table
CHAR_TRIP //Primary Key.
CHAR_DATE
AC_NUMBER //Foreign Key References Aircraft.
CHAR_DESTINATION
CHAR_DISTANCE
CHAR_HOURS_FLOWN
CHAR_HOURS_WAIT
CHAR_FUEL_GALLONS
CHAR_OIL_QTS
CUS_CODE /References Customer table.

CREW-table
CHAR_TRIP //Both these together form the primary key. And CHAR_TRIP References Charter table.
EMP_NUM //References Employee table.
CREW_JOB

CUSTOMER-table
CUS_CODE //Primary key.
CUS_LNAME
CUS_FNAME
CUS_INITIAL
CUS_AREACODE
CUS_PHONE
CUS_BALANCE

EARNEDRATING-table
EMP_NUM //Both the Emp_Num, and Earnrtg_Date together form the primary key. Emp_Num References Employee table.
RTG_CODE //References Rating table.
EARNRTG_DATE

EMPLOYEE-table
EMP_NUM //Primary Key.
EMP_TITLE
EMP_LNAME
EMP_FNAME
EMP_INITIAL
EMP_DOB
EMP_HIRE_DATE

MODEL-table
MOD_CODE //Primary Key. If a Model can be manufactured by more than one manufacturer, then we should consider MOD_CODE, and MOD_MANUFACTURER together as Primary key.
MOD_MANUFACTURER
MOD_NAME
MOD_SEATS
MOD_CHG_MILE

PILOT-table
EMP_NUM //References Employee Table.
PIL_LICENSE //Primary Key.
PIL_RATINGS
PIL_MED_TYPE
PIL_MED_DATE
PIL_PT135_DATE

RATING-table
RTG_CODE //Primary Key.
RTG_NAME

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

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