ISM 4212 Sample Exam 5     

Situation: A used car lot has cars for sale. Each car has a price, a year, a model, and a make. Cars are sold. Salespersons get commissions on sales. The commission rate may be different for each salesperson.

Information requirements: 1. List the cars for sale in order by make and model. 2. List the cars for sale in descending order by price. 3. List the cars for sale in descending order by year. 4. List the sales in order by salesperson. 5. List the sales with the commission amount in order by salesperson.

For the above situation: Develop an ERD for a database which supports ONLY the information requirements specifically listed and numbered. Include all of your attributes on the ERD. Denote PKs. Develop SQL Create Table statements for the database design.