CSCI 3310 Test1 Fall 2018 Name 2. (10 pts) Design a database to store details ab
ID: 3746970 • Letter: C
Question
CSCI 3310 Test1 Fall 2018 Name 2. (10 pts) Design a database to store details about US presidents and their term in office. You are required to record the sequence of presidents so that the predecessor and successor of any president can be determined. Grover Cleveland had nonconsecutive terms, so your model must handle this situation (hint: think of Presidency as an entity). Cleveland was both the 22nd (1885-89) and 24th (1893-97) President of the US. Also, record the fact that the sons of two Presidents (Adams and Bush) have also been Presidents (i.e., there is a father-son relationship between some presidents)Explanation / Answer
There can be a table consisting of Present name, the period he was in office.
Also there are additional details consisting of Vice Presedient and First Lady
[Martha Wayles Skelton Jefferson
died before Jefferson assumed office;
no image of her in P&P collections]
For giving out the Father-Son relationship we can create another table which will have President name, their relationship with other president and the name of other president.
The second table can be joined with the first table with the help of President column.
John Adams
YEAR PRESIDENT FIRST LADY VICE PRESIDENT 1789-1797 George Washington Martha Washington John Adams 1797-1801 John Adams Abigail Adams Thomas Jefferson 1801-1805 Thomas Jefferson[Martha Wayles Skelton Jefferson
died before Jefferson assumed office;
no image of her in P&P collections]
(no image) Daniel D. Tompkins 1825-1829 John Quincy Adams Louisa Catherine Adams John C. Calhoun 1829-1832 Andrew Jackson Rachel Jackson John C. Calhoun 1833-1837 Andrew Jackson Rachel Jackson Martin Van Buren 1837-1841 Martin Van Buren Hannah Hoes Van Buren Richard M. Johnson 1841 William Henry Harrison Anna Tuthill Symmes Harrison John Tyler 1841-1845 John Tyler Letitia Christian Tyler and
Julia Gardiner Tyler (no images) office vacant 1845-1849 James K. Polk Sarah Childress Polk George M. Dallas 1849-1850 Zachary Taylor Margaret Mackall Smith Taylor
(no image) Millard Fillmore 1850-1853 Millard Fillmore Abigail Powers Fillmore office vacant 1853 Franklin Pierce Jane M. Pierce William R. King 1853-1857 Franklin Pierce Jane M. Pierce office vacant 1857-1861 James Buchanan (never married) John C. Breckinridge 1861-1865 Abraham Lincoln Mary Todd Lincoln Hannibal Hamlin 1865 Abraham Lincoln Mary Todd Lincoln Andrew Johnson 1865-1869 Andrew Johnson Eliza McCardle Johnson office vacant 1869-1873 Ulysses S. Grant Julia Dent Grant Schuyler Colfax 1873-1875 Ulysses S. Grant Julia Dent Grant Henry Wilson 1875-1877 Ulysses S. Grant Julia Dent Grant office vacant 1877-1881 Rutherford Birchard Hayes Lucy Webb Hayes William A. Wheeler 1881 James A. Garfield Lucretia Rudolph Garfield Chester A. Arthur 1881-1885 Chester A. Arthur Ellen Lewis Herndon Arthur office vacant 1885 Grover Cleveland Frances Folsom Cleveland Thomas A. Hendricks 1885-1889 Grover Cleveland Frances Folsom Cleveland office vacant 1889-1893 Benjamin Harrison Caroline Lavinia Scott Harrison
Mary Lord Harrison
[Harrison's second wife,
but never a first lady] Levi P. Morton 1893-1897 Grover Cleveland Frances Folsom Cleveland Adlai E. Stevenson 1897-1899 William McKinley Ida Saxton McKinley Garret A. Hobart 1899-1901 William McKinley Ida Saxton McKinley office vacant 1901 William McKinley Ida Saxton McKinley Theodore Roosevelt 1901-1905 Theodore Roosevelt Edith Kermit Carow Roosevelt office vacant 1905-1909 Theodore Roosevelt Edith Kermit Carow Roosevelt Charles W. Fairbanks 1909-1912 William H. Taft Helen Herron Taft James S. Sherman 1912-1913 William H. Taft Helen Herron Taft office vacant 1913-1921 Woodrow Wilson Ellen Axson Wilson and
Edith Bolling Galt Wilson Thomas R. Marshall 1921-1923 Warren G. Harding Florence Kling Harding Calvin Coolidge 1923-1925 Calvin Coolidge Grace Goodhue Coolidge office vacant 1925-1929 Calvin Coolidge Grace Goodhue Coolidge Charles G. Dawes 1929-1933 Herbert Hoover Lou Henry Hoover Charles Curtis 1933-1941 Franklin D. Roosevelt Eleanor Roosevelt John N. Garner 1941-1945 Franklin D. Roosevelt Eleanor Roosevelt Henry A. Wallace 1945 Franklin D. Roosevelt Eleanor Roosevelt Harry S. Truman 1945-1949 Harry S. Truman Bess Wallace Truman office vacant 1949-1953 Harry S. Truman Bess Wallace Truman Barkley, Alben W. 1953-1961 Dwight D. Eisenhower Mamie Doud Eisenhower Richard M. Nixon 1961-1963 John F. Kennedy Jacqueline Kennedy Onassis Lyndon B. Johnson 1963-1965 Lyndon B. Johnson Lady Bird Johnson office vacant 1965-1969 Lyndon B. Johnson Lady Bird Johnson Hubert H. Humphrey 1969-1973 Richard M. Nixon Pat Nixon Spiro T. Agnew 1973-1974 Richard M. Nixon Pat Nixon Gerald R. Ford 1974-1977 Gerald R. Ford Betty Ford Nelson Rockefeller 1977-1981 Jimmy Carter Rosalynn Carter Walter F. Mondale 1981-1989 Ronald Reagan Nancy Reagan George Bush 1989-1993 George Bush Barbara Bush Dan Quayle 1993-2001 Bill Clinton Hillary Rodham Clinton Albert Gore 2001-2009 George W. Bush Laura Bush Richard Cheney 2009-2017 Barack Obama Michelle Obama Joseph R. Biden 2017- Donald J. Trump Melania Trump Mike Pence