Exericse: Managing a PC shop inventory

2020-10-31| YouTube explanation (German) | IHK final exam Summer 2003, GH2 Exercise 6

For managing the inventory of his PC shop, the owner uses an Excel sheet. The following screenshot contains the current format:

Screenshot of CSV file

The owner wants to migrate this Excel sheet to a relational database.

  • How must a relational database must look like?
  • What primary keys have to be used?
  • What is referential integrity?