Solution to Exercise 1
Solution to exercise 1.
We'll cover the following...
Solution
The ER diagram derived from our requirements is shown below. The diagram uses some advanced features, including relationships that have attributes and weak entity types.
Explanation
In our design:
-
STUDENT is a strong entity, with an identifier,
Student_Id
...