Draw data models for the following entities. In each case, make certain that you show the attributes and identifiers. Also, create a relational database and insert three rows for each of the tables that you create. The data can be anything you create that fits within any constraints specified in the problem. You should submit a file with the data model drawn and the SQL used to create and populate the tables.

1. Design a database to store details about U.S. presidents and their terms in office. Also, record details of their date and place of birth, gender, and political party affiliation (e.g., Caluthumpian Progress Party). You are required to record the sequence of presidents so the predecessor and successor of any president can be identified. How will you model the case of Grover Cleveland who served nonconsecutive terms as president? Is it feasible that political party affiliation may change? If so, how will you handle it? In populating your solution include the following information (note this is not the format you will store it in the database):

Chester	Arthur	Born 10/05/1829	Whig until 01/01/1854	Republican after that	21st president
Grover	Cleveland	Born 03/18/1837	Democrat his entire career	22nd President	24th President
Benjamin	Harrison	Born 08/20/1833	Whig until 01/01/1856	Republican after that	23rd President