Question: Part 1: Database Model Create a database model while following the steps listed below: Create a simple class diagram containing three classes: Vehicle, Car, and
Part 1: Database Model
Create a database model while following the steps listed below:
Create a simple class diagram containing three classes: Vehicle, Car, and Truck. Provide two attributes for each of these three classes.
Create a rough sketch of a relational table that will store the objects belonging to the aforementioned three classes.
Ensure you have tried all three optionssingle table, two tables, and three tablesin your database design.
Enter two objects per table, corresponding to the classes.
Use the two-table design to recreate a Car object.
Repeat the preceding step to recreate a Truck object.
Create a simple association relationship in a separate class diagram showing Driver and Car.
Apply a multiplicity of 1 on the driver side and N on the Car side.
Add/modify your table designs to handle storing of two objects belonging to Car and two belonging to Driver.
Modify the multiplicity on the Driver side to N. This makes it a many-to-many multiplicity.
Modify your table designs to handle this multiplicity and show where and how the KEYS or IDs will have to be placed.
Create a class diagram corresponding to the tables you have designed. Stereotype all classes on that class diagram as <
Study Help