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 eg 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 ie they may get their vehicle loan from one bank
and have their bank accounts 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 ie they
are retired or independently wealthy A company must have at least one employee.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
