Exercises

If you want some more practice with creating ERDs, you can use the following two exercises. You can find the solutions to the exercises in the downloads for this book.

Exercise 1 – student registration

A well-known course provider located centrally in the country needs a system to plan their courses and keep track of which students follow which courses when. They have many courses you can follow. Each course is part of a curriculum that makes courses easier to find on the website. A course may be taught by a teacher employed by the institute or by an independent contractor. For each course leader, we must know which courses they are able to deliver. We also need to be able to quickly show which courses were delivered most recently and which course a teacher delivers the most. For freelancers, they keep track of extra information, such as registration with the chamber of commerce.

Courses are not provided to private individuals. Students are registered by their...