need help drawing data models
Your submission should be a computer typed document that includes the models created and the code used to create the tables, populate the tables, and query the tables. I do not need to see screen shots of the database or a have a database submitted. Submit this via Blackboard and be prepared to discuss in class. 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 vear 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 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): Chester Arthur Bor 10/05/1829 Whig until 01/01/1854 Genver Cleveland Bom 0318/1837 Democrat his entire Republican after 21st president President President Republicanaler 23President 22 Presiden 24" President Benjamin Harrison Bom 08/20/1833 Whig until 01/01/1856
