Consider the E-R diagram in Figure 7-7.
a. What is the identifier for the CERTIFICATE associative entity?
b. Now, assume that the same employee may take the same course multiple times, on different dates. Does this change your answer to part a? Why or why not?
c. Now, assume we do know the instructor who issues each certificate to each employee for each course. Include this new entity in Figure 7-7 and relate it to the other entities. How did you choose to relate INSTRUCTOR to CERTIFICATE and why?