sale design

Project Description:

fabrico motors’ dealership sells fords, hondas, and toyotas. the dealership keeps information about each car manufacturer with whom it deals so that employees can get in touch with manufacturers easily. the dealership also keeps information about the models of cars that it carries from each manufacturer. it keeps such information as list price, the price the dealership paid to obtain the model, and the model name and series (e.g. honda civic lx). the dealership also keeps information about all sales that it has made. (for instance, employees will record the buyer’s name, the car the buyer bought, and the amount the buyer paid for the car.) to allow employees to contact the buyers in the future, contact information is also kept (e.g. address, phone number, e-mail).
for the above situation, answer the following questions.
a
what are the entities of interest identifiable?
b
identify the attributes of entities and the relationship existing amongst these entities
c
what are the constraints on relationship types?
d
draw the corresponding e-r diagram
e
map your diagram in (d) into relational schema and identify all candidate keys
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: $0 to $10
Expired
Total Proposals: 4
1 Current viewersl
30 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.9
    1181 Jobs 609 Reviews
    $40 in 2 Days
  • 4.7
    31 Jobs 16 Reviews
    $30 in 2 Days
  • 4.8
    12 Jobs 8 Reviews
    $35 in 3 Days
  • 4.5
    38 Jobs 27 Reviews
    $40 in 1 Day