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.

a. A student can attend more than one class, and the same class can have many students. For each student track their id number, name, gender, and birthdate. For each class track the title and instructor. Be sure to record which semester and year each student took each class. Remember if a student doesnt do well they may take the same class twice in different semesters.

b. 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	21stpresident
Grover	Cleveland	Born 03/18/1837	Democrat his entire career	22ndPresident	24thPresident
Benjamin	Harrison	Born 08/20/1833	Whig until 01/01/1856	Republican after that	23rdPresident