

CREATE TABLE Administration (
   Admin_Nr         DECIMAL(4,0)  NOT NULL,
   Pres_Name        CHAR(15) NOT NULL,
   Year_Inaugurated DECIMAL(4,0) NOT NULL,
   PRIMARY KEY (Admin_Nr,Pres_Name),
   FOREIGN KEY (Pres_Name) REFERENCES President(Pres_Name));

CREATE TABLE Admin_Pr_Vp (
   Admin_Nr       DECIMAL(4,0) NOT NULL,
   Pres_Name      CHAR(15) NOT NULL,
   Vice_Pres_Name CHAR(17) NOT NULL,
   PRIMARY KEY (Admin_Nr, Pres_Name, Vice_Pres_Name),
   FOREIGN KEY (Admin_Nr,Pres_Name) REFERENCES Administration(Admin_Nr,Pres_Name));

INSERT INTO  Administration VALUES (1,'Washington G',1789);
INSERT INTO  Administration VALUES (2,'Washington G',1793);
INSERT INTO  Administration VALUES (3,'Adams J',1797);
INSERT INTO  Administration VALUES (4,'Jefferson T',1801);
INSERT INTO  Administration VALUES (5,'Jefferson T',1805);
INSERT INTO  Administration VALUES (6,'Madison J',1809);
INSERT INTO  Administration VALUES (7,'Madison J',1813);
INSERT INTO  Administration VALUES (8,'Monroe J',1817);
INSERT INTO  Administration VALUES (9,'Monroe J',1821);
INSERT INTO  Administration VALUES (10,'Adams J Q',1825);
INSERT INTO  Administration VALUES (11,'Jackson A',1829);
INSERT INTO  Administration VALUES (12,'Jackson A',1833);
INSERT INTO  Administration VALUES (13,'Van Buren M',1837);
INSERT INTO  Administration VALUES (14,'Harrison W H',1841);
INSERT INTO  Administration VALUES (14,'Tyler J',1841);
INSERT INTO  Administration VALUES (15,'Polk J K',1845);
INSERT INTO  Administration VALUES (16,'Taylor Z',1849);
INSERT INTO  Administration VALUES (16,'Fillmore M',1850);
INSERT INTO  Administration VALUES (17,'Pierce F',1853);
INSERT INTO  Administration VALUES (18,'Buchanan J',1857);
INSERT INTO  Administration VALUES (19,'Lincoln A',1861);
INSERT INTO  Administration VALUES (20,'Lincoln A',1865);
INSERT INTO  Administration VALUES (20,'Johnson A',1865);
INSERT INTO  Administration VALUES (21,'Grant U S',1869);
INSERT INTO  Administration VALUES (22,'Grant U S',1873);
INSERT INTO  Administration VALUES (23,'Hayes R B',1877);
INSERT INTO  Administration VALUES (24,'Garfield J A',1881);
INSERT INTO  Administration VALUES (24,'Arthur C A',1881);
INSERT INTO  Administration VALUES (25,'Cleveland G',1885);
INSERT INTO  Administration VALUES (26,'Harrison B',1889);
INSERT INTO  Administration VALUES (27,'Cleveland G',1893);
INSERT INTO  Administration VALUES (28,'McKinley W',1897);
INSERT INTO  Administration VALUES (29,'McKinley W',1901);
INSERT INTO  Administration VALUES (29,'Roosevelt T',1901);
INSERT INTO  Administration VALUES (30,'Roosevelt T',1905);
INSERT INTO  Administration VALUES (31,'Taft W H',1909);
INSERT INTO  Administration VALUES (32,'Wilson W',1913);
INSERT INTO  Administration VALUES (33,'Wilson W',1917);
INSERT INTO  Administration VALUES (34,'Harding W G',1921);
INSERT INTO  Administration VALUES (34,'Coolidge C',1923);
INSERT INTO  Administration VALUES (35,'Coolidge C',1925);
INSERT INTO  Administration VALUES (36,'Hoover H C',1929);
INSERT INTO  Administration VALUES (37,'Roosevelt F D',1933);
INSERT INTO  Administration VALUES (38,'Roosevelt F D',1937);
INSERT INTO  Administration VALUES (39,'Roosevelt F D',1941);
INSERT INTO  Administration VALUES (40,'Roosevelt F D',1945);
INSERT INTO  Administration VALUES (40,'Truman H S',1945);
INSERT INTO  Administration VALUES (41,'Truman H S',1949);
INSERT INTO  Administration VALUES (42,'Eisenhower D D',1953);
INSERT INTO  Administration VALUES (43,'Eisenhower D D',1957);
INSERT INTO  Administration VALUES (44,'Kennedy J F',1961);
INSERT INTO  Administration VALUES (44,'Johnson L B',1963);
INSERT INTO  Administration VALUES (45,'Johnson L B',1965);
INSERT INTO  Administration VALUES (46,'Nixon R M',1969);
INSERT INTO  Administration VALUES (47,'Nixon R M',1973);
INSERT INTO  Administration VALUES (47,'Ford G R',1974);
INSERT INTO  Administration VALUES (48,'Carter J E',1977);
INSERT INTO  Administration VALUES (49,'Reagan R',1981);
INSERT INTO  Administration VALUES (50,'Reagan R',1985);
INSERT INTO  Administration VALUES (51,'Bush G',1989);
INSERT INTO  Administration VALUES (52,'Clinton W J',1993);


INSERT INTO  Admin_Pr_Vp VALUES (1,'Washington G','Adams J');
INSERT INTO  Admin_Pr_Vp VALUES (2,'Washington G','Adams J');
INSERT INTO  Admin_Pr_Vp VALUES (3,'Adams J','Jefferson T');
INSERT INTO  Admin_Pr_Vp VALUES (4,'Jefferson T','Burr A');
INSERT INTO  Admin_Pr_Vp VALUES (5,'Jefferson T','Clinton G');
INSERT INTO  Admin_Pr_Vp VALUES (6,'Madison J','Clinton G');
INSERT INTO  Admin_Pr_Vp VALUES (7,'Madison J','Gerry E');
INSERT INTO  Admin_Pr_Vp VALUES (8,'Monroe J','Tompkins D');
INSERT INTO  Admin_Pr_Vp VALUES (9,'Monroe J','Tompkins D');
INSERT INTO  Admin_Pr_Vp VALUES (10,'Adams J Q','Calhoun J');
INSERT INTO  Admin_Pr_Vp VALUES (11,'Jackson A','Calhoun J');
INSERT INTO  Admin_Pr_Vp VALUES (12,'Jackson A','Van Buren M');
INSERT INTO  Admin_Pr_Vp VALUES (13,'Van Buren M','Johnson R M');
INSERT INTO  Admin_Pr_Vp VALUES (14,'Harrison W H','Tyler J');
INSERT INTO  Admin_Pr_Vp VALUES (15,'Polk J K','Dallas G M');
INSERT INTO  Admin_Pr_Vp VALUES (16,'Taylor Z','Fillmore M');
INSERT INTO  Admin_Pr_Vp VALUES (17,'Pierce F','De Vane King W R');
INSERT INTO  Admin_Pr_Vp VALUES (18,'Buchanan J','Breckinridge J C');
INSERT INTO  Admin_Pr_Vp VALUES (19,'Lincoln A','Hamlin H');
INSERT INTO  Admin_Pr_Vp VALUES (20,'Lincoln A','Johnson A');
INSERT INTO  Admin_Pr_Vp VALUES (21,'Grant U S','Colfax S');
INSERT INTO  Admin_Pr_Vp VALUES (22,'Grant U S','Wilson H');
INSERT INTO  Admin_Pr_Vp VALUES (23,'Hayes R B','Wheeler W');
INSERT INTO  Admin_Pr_Vp VALUES (24,'Garfield J A','Arthur C A');
INSERT INTO  Admin_Pr_Vp VALUES (25,'Cleveland G','Hendricks T A');
INSERT INTO  Admin_Pr_Vp VALUES (26,'Harrison B','Morton L P');
INSERT INTO  Admin_Pr_Vp VALUES (27,'Cleveland G','Stevenson A E');
INSERT INTO  Admin_Pr_Vp VALUES (28,'McKinley W','Hobart G A');
INSERT INTO  Admin_Pr_Vp VALUES (29,'McKinley W','Roosevelt T');
INSERT INTO  Admin_Pr_Vp VALUES (30,'Roosevelt T','Fairbanks C W');
INSERT INTO  Admin_Pr_Vp VALUES (31,'Taft W H','Sherman J S');
INSERT INTO  Admin_Pr_Vp VALUES (32,'Wilson W','Marshall T R');
INSERT INTO  Admin_Pr_Vp VALUES (33,'Wilson W','Marshall T R');
INSERT INTO  Admin_Pr_Vp VALUES (34,'Harding W G','Coolidge C');
INSERT INTO  Admin_Pr_Vp VALUES (35,'Coolidge C','Dawes C G');
INSERT INTO  Admin_Pr_Vp VALUES (36,'Hoover H C','Curtis C');
INSERT INTO  Admin_Pr_Vp VALUES (37,'Roosevelt F D','Garner J N');
INSERT INTO  Admin_Pr_Vp VALUES (38,'Roosevelt F D','Garner J N');
INSERT INTO  Admin_Pr_Vp VALUES (39,'Roosevelt F D','Wallace H A');
INSERT INTO  Admin_Pr_Vp VALUES (40,'Roosevelt F D','Truman H S');
INSERT INTO  Admin_Pr_Vp VALUES (41,'Truman H S','Barkley A W');
INSERT INTO  Admin_Pr_Vp VALUES (42,'Eisenhower D D','Nixon R M');
INSERT INTO  Admin_Pr_Vp VALUES (43,'Eisenhower D D','Nixon R M');
INSERT INTO  Admin_Pr_Vp VALUES (44,'Kennedy J F','Johnson L B');
INSERT INTO  Admin_Pr_Vp VALUES (45,'Johnson L B','Humphrey H H');
INSERT INTO  Admin_Pr_Vp VALUES (46,'Nixon R M','Agnew S T');
INSERT INTO  Admin_Pr_Vp VALUES (47,'Nixon R M','Agnew S T');
INSERT INTO  Admin_Pr_Vp VALUES (47,'Nixon R M','Ford G R');
INSERT INTO  Admin_Pr_Vp VALUES (47,'Ford G R','Rockefeller N A');
INSERT INTO  Admin_Pr_Vp VALUES (48,'Carter J E','Mondale W F');
INSERT INTO  Admin_Pr_Vp VALUES (49,'Reagan R','Bush G');
INSERT INTO  Admin_Pr_Vp VALUES (50,'Reagan R','Bush G');
INSERT INTO  Admin_Pr_Vp VALUES (51,'Bush G','Quayle D');
INSERT INTO  Admin_Pr_Vp VALUES (52,'Clinton W J','Gore A');




