Database Model

 

reate a database model according to the following steps:

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 options—single table, two tables, and three tables—in 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.

Sample Solution

possible to form an estimate of the time the war may last before the objects for which the Allies are fighting have been attained. But the Somme battle has placed beyond doubt the ability of the Allies to gain those objects” (“Sir Douglas Haig, British Commander-in-Chief in France and Flanders, 2nd Dispatch”, 37). The mentality of the Allies was that the Battle of the Somme was a precursor to an end for the war because the Battle of the Somme had thoroughly extended German manpower and resources. The Allies also had a renewed confidence in their abilities that heightened their determination to eventually overpower Germany and the rest of the Central Powers. Crown Prince Rupprecht had a similar opinion to Sir Douglas Haig regarding when the war was going to be won. He said, “The offensive will certainly not be at an end very soon. One may well look forward to an offensive of great endurance” (“The Battle of the Somme by Crown Prince Rupprecht”, 39). This statement demonstrates the generally accepted belief that fighting would continue for some time. Crown Prince Rupprecht also firmly stated, “I am of the opinion that the enemy is seeking a decision here and this year, and in this he has failed” (“The Battle of the Somme by Crown Prince Rupprecht”, 39). Both Sir Douglas Haig and Crown Prince Rupprecht agreed that the war was not over following the Battle of the Somme, but cannot comprehend the war lasting another two years. It is reasonable to think that they believed World War I would be over sometime during 1917.

World War I was a long, complex series of battles of which only an armistice was accomplished, and one of its bloodiest battles was the Battle of the Somme. The Allies were very effective during this battle through their utilization of the frontal attack, sheer willpower, a well-planned combined offensive, and new military technology. The Allies achieved their goals and proved that they were a powerful force against the well-equipped, well-trained Germans. Ultimately, the Battle of the Somme did not mean a decisive victory or even the end of the war was at hand, but it gave the Allies necessary confidence and crippled the German army.

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.