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?

Answer rating: 100% (QA)

1 Identifiable assets consist of anything that can be separated from the business and disposed of such as machinery vehicles buildings or other equipm... View the full answer