Before you keep reading...

Runestone Academy can only continue if we get support from individuals like you. As a student you are well aware of the high cost of textbooks. Our mission is to provide great books to you for free, but we ask that you consider a $10 donation, more if you can or less if $10 is a burden.

Support Runestone Academy Today

Joe Celko’s page examples¶

DROP TABLE IF EXISTS PilotSkills;

CREATE TABLE PilotSkills
 (pilot_name CHAR(15) NOT NULL,
 plane_name CHAR(15) NOT NULL,
 PRIMARY KEY (pilot_name, plane_name));

DROP TABLE IF EXISTS Hangar;
 CREATE TABLE Hangar
 (plane_name CHAR(15) NOT NULL PRIMARY KEY);

INSERT INTO PilotSkills VALUES ('Celko',    'Piper Cub');
 INSERT INTO PilotSkills VALUES ('Higgins',  'B-52 Bomber');
 INSERT INTO PilotSkills VALUES ('Higgins',  'F-14 Fighter');
 INSERT INTO PilotSkills VALUES ('Higgins',  'Piper Cub');
 INSERT INTO PilotSkills VALUES ('Jones',    'B-52 Bomber');
 INSERT INTO PilotSkills VALUES ('Jones',    'F-14 Fighter');
 INSERT INTO PilotSkills VALUES ('Smith',    'B-1 Bomber');
 INSERT INTO PilotSkills VALUES ('Smith',    'B-52 Bomber');
 INSERT INTO PilotSkills VALUES ('Smith',    'F-14 Fighter');
 INSERT INTO PilotSkills VALUES ('Wilson',   'B-1 Bomber');
 INSERT INTO PilotSkills VALUES ('Wilson',   'B-52 Bomber');
 INSERT INTO PilotSkills VALUES ('Wilson',   'F-14 Fighter');
 INSERT INTO PilotSkills VALUES ('Wilson',   'F-17 Fighter');

INSERT INTO Hangar VALUES ('B-1 Bomber');
 INSERT INTO Hangar VALUES ('B-52 Bomber');
 INSERT INTO Hangar VALUES ('F-14 Fighter');

Exact division as proposed by Celko