Question: Draw data models for the following entities. In each case, make certain that you show the attributes and identifiers. Also, create a relational database (write
Draw data models for the following entities. In each case, make certain that you show the attributes and identifiers. Also, create a relational database (write a code that will create the table in SQL) 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.
- 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.
- Cow: A dairy cow has a name, date of birth, breed (e.g., Holstein), and a numbered plastic ear tag.
- 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 students social security number, name (should first and last name be in the same field?), street address, city, state, and zip code.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
