- CREATE TABLE plane(reg_no varchar(10),model_no varchar(10) Primary Key(reg_no,model_no) FOREIGN KEY(model_no) REFERENCES model(model_no) );
- CREATE TABLE model_no(model_no varchar(10),capacity varchar(5),weight varchar(5),PRIMARY KEY(model_no,);
- CREATE TABLE test(FAA_no varchar(10),name varchar(10) , score varchar(5) , PRIMARY KEY(FAA_NO);
- CREATE TABLE employee(SSN varchar(10), name varchar(25), address varchar(50), phone_no varchar(12), PRIMARY KEY(SSN))
- CREATE TABLE technician(SSN VARCHAR(10),salary integer,PRIMARY KEY(SSN),FOREIGN KEY(SSN) REFRENCES employee);
- CREATE table Traffic_controller(SSN VARCHAR(10),PRIMARY KEY(SSN) FOREIGN KEY(SSN) REFERENCES employee)
- CREATE TABLE testDetails(faa_no integer,date DATE,hours INTEGER,score INTEGER,PRIMARY KEY(reg_no,ssn,FA_no,date),FOREIGN KEY(reg_no)refrences model,FOREIGN KEY(SSN) refrences employee,FOREIGN KEY(FAA_NO) REFRENCES TEST);