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