Exercises
Exercise 1 – Stock management of a bicycle shop
A bicycle shop specializing in high-end road bikes has trouble keeping their stock supplies at acceptable levels. We therefore created a new database to help them get a better insight into the products they have in stock.
The shop has a list of suppliers. Many products can be bought through different suppliers. In this process, it is important to know which list price each supplier is using and what the delivery time is. Based on that information, a purchaser orders new products:
- Draw an ERD based on the description provided. Use your entity analysis skills, as acquired in Chapter 2, Entity Analysis. You will normalize the data in later steps in this exercise.
- Normalize each report as shown in Figures 3.17, 3.18, and 3.19 individually.
Figure 3.17 shows a paper-based purchase order:
Figure 3.17 – Purchase order
Figure 3.18 shows a warehouse card that can be printed...