Fabrico motors dealership sells fords, Hondas and Toyota’s.

Fabrico motors dealership sells fords, Hondas and Toyota’s. 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 carriers 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 buyers 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)

1. What are the entities of interest identifiable

2.Identify the attributes of entities and the relationship existing amongst these entities

3. What are the constraints on relationship types

4.draw the corresponding E-R diagram

5 Map your diagram in (4) into relational schema and identity all candidate keys

Leave a Reply