need help building data models

Part 1: Draw data models for the following entities using Visio or another modeling tool. 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. a. Car: A car has a manufacturer, model, and style code (e.g., a Honda Accord DX, where Honda is the manufacturer, Accord is the model, and DX is the style). A car also has a vehicle identification code, registration code, and color. b. A university has many students, and a student can attend at most one university. For each university capture the university name, city, and mascot. For each student capture the student's social security number, name (should first and last name be in the same field?), street address, city, state, and zip code. c. 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 doesn't do well they may take the same class twice in different semesters. d. 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) Republican after 21st president Chester Arthur Bom 10/06/1829 Whig until 01/01/1854 Grover Cleveland Born 03/18/1837 Democrat his entire 22 President 24 President Benjamin Harrison Born 08/20/1833 Whig until 01/01/1856 Republican after 23" President