Question: We would like to design a database for a Vehicle. Based on the following description, draw the corresponding ER diagram by: Specifying the entities, Specifying

We would like to design a database for a "Vehicle". Based on the following description,
draw the corresponding ER diagram by:
Specifying the entities,
Specifying the relationships between entities,
Specifying the multiplicities (min, max) of each relationship.
A person may own several vehicles (e.g., car, pickup, truck. Etc.) or none, but only
one person owns each vehicle. Every vehicle must have an owner. Some vehicles may
be paid for by a loan given by a bank. A vehicle may have at most one loan, but a bank
can give loans for many vehicles. A person may or may not do their banking at the bank
from which they get the vehicle loan (i.e., they may get their vehicle loan from one bank
and have their bank account(s) at another bank). Every person has a bank account. A
person can work for at most one company but may not work for any company (i.e., they
are retired or independently wealthy). A company must have at least one employee.
 We would like to design a database for a "Vehicle". Based

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!