(Q) You want to keep information on past sales at a motorcycle dealership, including information on motorcycles, salespeople, and customers. Assume that the dealership sells only new motorcycles and all of them come from the same manufacturer.

For each salesperson, you want to store their first name, last name, middle name/initial, employee ID number, and date hired. For each customer, you want to store a customer ID number, first name, last name, middle name/initial, address information, phone number, and e?mail address.

Each kind of motorcycle is called a model, and has unique model number. For each model, you want to store its name, engine size in cubic centimeters (CC) (an integer), and the date introduced. Each individual motorcycle sold is identified by a unique 16?digit serial "number" (which may also contain letters). For each motorcycle sale, you want to record the serial number, date of sale, and sale price. You also want to know which customer bought the motorcycle, which salesperson made the sale, and what model the motorcycle was. (END Q)

-- I want to learn how to build an ER diagram using the information given in this question above. I have been working on this problem & am having difficulties creating the necessary relationships to solve further steps in MS Access (not listed here). I have been able to design the database outline given the information above (I think correctly), but am running into trouble with the relationships between the tables further on when crafting forms/etc. If you could walk me through steps of how to build an ER diagram like the one above and work out functional relationships that would work in MS Access, that would help me immensely and allow me to check & correct (if necessary) my work.

pur-new-sol

Related Questions