Give you first-hand experience modeling associations between classes in UML and relation scheme diagrams.
We want to capture some information regarding automobiles in the context of the Department of Motor Vehicles. Your scope is limited to:
Each driver has a driver’s license number and a state of the United States that issued that driver’s license. The driver’s license number is only unique within each state. Two drivers could have the same driver’s license number, if they are not from the same state.
Each licensed driver has a last name.
Each licensed driver has a first name.
We are not going to assume that the name of the driver is unique.
We want to make sure that the clerk entering the information about licensed drivers never inputs an invalid state name.
Each state is identified by a two-character state code. For instance, California is CA, Washington is WA.
Each state also has a unique name, which is always longer than the state code. It is up to you which one to use for the primary key.
A car has a unique Vehicle Identification Number issued to it which identifies that vehicle. In our work, we term this an “external key” because an external agency issues this ID.
A car also has a make, and year.
The make, or manufacturer, is limited to several possible values like
‘Toyota’, ‘Chevrolet’, ‘Mercedes Benz’, and so forth.
Here again, we want to be sure that no one can enter an invalid make
for a vehicle.
A car may have an owner. The owner must be a licensed driver.
We are only going to track the current owner of the vehicle.
I have been told that California allows multiple owners to appear on one pink slip. For our purposes, we will ignore that annoying fact
until later when we get into many to many associations.
If the car has an owner, we capture the date on which that owner took
ownership of that vehicle.
a. Try to think of a way to make sure that you do not have to have any
optional attributes in car.
CECS 323 MHW ASSOCIATIONS
Using diagrams.net, develop the corresponding relation scheme diagram.
a. Note, you can put both diagrams into one .drawio file if you like. Use the “+” button at the bottom of the window to add a fresh page. Double-clicking the named tab at the bottom allows you to rename the page.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more