5. A friend of yours is starting a business to build semi-customized cases for cell phones and laptops. The focus of the case is in the design—colors, logos, artwork and so on. She plans to buy relatively plain cases and then paint them with various designs. She can even take photographs from customers and incorporate those into the artwork. Existing stores and Web sites focus on finding a case to fit a particular device, but she thinks the process should work the other direction. Customers will pick the design and artwork and then specify the device. Cases for popular devices will be supported automatically and kept in stock, but other devices will take time to customize. The device aspect ratio is a particular problem because the artwork is relatively easy to scale up or down in size but not if the ratio of width to height changes too far. Then it has to be redrawn. And Apple devices tend to use the older 4:3 aspect ratio compared to other companies that use the newer HD 16:9 ratio.
This exercise is in the Database Design system. Try to solve it there first.
Possible tables:
Customer(*CustomerID, ...)
Device(*DeviceID, ...)
Category(*Category) - - - lookup table
PaymentMethod(*PaymentMethod) - - - lookup table
Design(*DesignID, ...)
Artist(*ArtistID, ...)
Sale(*SaleID, CustomerID, ...)
SaleItem(*SaleID, *DesignID, *DeviceID, ...)
DeviceDesigns(*DesignID, *DeviceID, ....)