Chapter 6 Running Case Assignment: Improving Decision Making: Redesigning
the Customer Database
Software skills: Database design; querying and reporting
Business skills: Customer profiling
Dirt Bikes U.S.A. sells primarily through its distributors. It maintains a small customer
customers own two or three motorcycles purchased from Dirt Bikes U.S.A. or other
manufacturer.) If a motorcycle was purchased from Dirt Bikes, the company would like
to know the date of purchase, model purchased, and distributor. If the customer owns a
non–Dirt Bikes motorcycle, the company would like to know the manufacturer and
model of the other motorcycle (or motorcycles) and the distributor from whom the