Create a simple class diagram containing three classes

Question

Assignment: Database Model Draft

Create a database model according to the following steps:

1) Create a simple class diagram containing three classes: Vehicle, Car, and Truck. Provide two attributes for each of these three classes.

a) Create a rough sketch of a relational table that will store the objects belonging to the aforementioned three classes.
b) Ensure you have tried all three options-single table, two tables, and three tables-in your database design.
c) Enter two objects per table, corresponding to the classes.

2) Use the two-table design to recreate a Car object.

3) Repeat the preceding step to recreate a Truck object.

4) Create a simple association relationship in a separate class diagram showing Driver and Car.

a) Apply a multiplicity of 1 on the driver side and N on the Car side.

5) Add/modify your table designs to handle storing of two objects belonging to Car and two belonging to Driver.

a) Modify the multiplicity on the Driver side to N. This makes it a many-to-many multiplicity.

6) Modify your table designs to handle this multiplicity and show where and how the KEYS or IDs will have to be placed.

7) Create a class diagram corresponding to the tables you have designed. Stereotype all classes on that class diagram as <

>.

Format your assignment according to the following formatting requirements:

(1) The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.

(2) The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.

(3) Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.

View Complete Question

Request for Solution File

Ask an Expert for Answer!!

Database Management System: Create a simple class diagram containing three classes

Reference No:- TGS03115230

Expected delivery within 24 Hours

Have a Question? (oR Write a Review)

Write atleast 100 words!!

   Recent Questions Asked Database Management System

Q : Install ubuntu on your own machine You are required to download it to your computer. Following the instructions in the tutorial below, install Ubuntu on your own machine.

Q : Discuss the advantages and challenges of distributed systems Discuss the advantages and challenges of distributed systems. Explain the components of the Linux operating system and include an illustration.

Q : Describe several situations imagined where good policy Describe several situations, imagined or actual, where good policy intentions could work in your favor, or go astray.

Q : What are the advantages of different storage mechanisms What are the advantages and limitations of different storage mechanisms for objects? How can an object be mapped to a relational storage?

Q : Create a simple class diagram containing three classes Create a simple class diagram containing three classes: Vehicle, Car, and Truck. Provide two attributes for each of these three classes.

Q : Create a sequence diagram of a hospital management system create a sequence diagram of a hospital management system. Include the following notations: actor, object, timeline, focus of control, message and self-message.

Q : What is difference between animation and transition effects What is the difference between animation and transition effects? Why is it important for the slides to be uniform in FONT and Design?

Q : In what countries does the company manufacture motor vehicle In what countries does the company manufacture motor vehicles, and why might the company have picked those countries for manufacturing operations?

Q : List two examples of weaknesses and threats List two examples of Strengths and Opportunities (SO) within the organization. List two examples of Weaknesses and Threats (WT).