姓名：許恒睿 ID：109704001

1.

hw2DBMS.drawio (3).png

2.a The Primary Key

TABLE PRIMARY KEY
CHARTER CHAR_TRIP
AIRCRAFT AC_NUMBER
MODEL MOD_CODE
PILOT EMP_NUM
EMPLOYEE EMP_NUM
CUSTOMER CUS_CODE

2.b A Superkey

(備註：公告說只要列一種，PK都算super key)

TABLE SUPER KEY
CHARTER CHAR_TRIP
AIRCRAFT AC_NUMBER
MODEL MOD_CODE
PILOT EMP_NUM
EMPLOYEE EMP_NUM
CUSTOMER CUS_CODE

2.c The Foreign Key(s)

TABLE FOREIGN KEY
CHARTER CHAR_PILOT, CHAR_COPILOT, AC_NUMBER, CUS_CODE
AIRCRAFT MOD_CODE
MODEL NONE
PILOT EMP_NUM
EMPLOYEE NONE
CUSTOMER NONE