Discussion Questions

1
Discussion Questions

• 2.6/3.16

2
Create Table Airplanes (

• Reg_id char(10) NOT NULL
• PRIMARY KEY (reg_id)
• )

3
Create Table Model (

• Model_no char(10) NOT NULL,
• Capacity int(4),
• Weight float
• PRIMARY KEY (model_no)
• )

4
Create Table Employee (

• Ssn char(11) NOT NULL,
• LastName varchar(50) NOT NULL,
• FirstName varchar(50) NOT NULL,
• Address blob,
• phoneNum varchar(15),
• Salary int(6),
• unionNum char(10) NOT NULL
• PRIMARY KEY (ssn)
• KEY (unionNum) )

5
Create Table Test (

• FAAno char(12) NOT NULL,
• testName varchar(50) NOT NULL,
• maxScore int(3) NOT NULL Default 100
• PRIMARY KEY (FAAno)
• KEY (testName)
• )

6
Create Table Airplanes (

• Reg_id char(10) NOT NULL,
• modelNo char(10) NOT NULL
• PRIMARY KEY (reg_id),
• FOREIGN KEY (modelNo) REFERENCES Model
• )

7
Create Table Expert (

• modelNo char (10) NOT NULL,
• Ssn char(15) NOT NULL
• PRIMARY KEY (modelNo, Ssn),
• FOREIGN KEY (modelNo) REFERENCES Model,
• FOREIGN KEY (ssn) REFERENCES Technician
• )

8
Create Table TestInfo (

• FAAno char(12) NOT NULL,
• regNo char(10) NOT NULL,
• Ssn char(15) NOT NULL,
• Hours int(2),
• Date Date,
• Score int(3)
• PRIMARY KEY (FAAno, regNO, Ssn),
• FOREIGN KEY (Ssn) references Technician,
• FOREIGN KEY (regNo) references Airplane,
• FOREIGN KEY (FAAno) references Test )