Exercise: faculty degrees

A number of years ago, I taught evening courses at a small college extension center. The center staff kept a list of faculty members in one of the very early PC-based “database” programs. There was only one faculty table, part of which looked like this:

Faculty degrees class diagram

• No, I’m not making this up. There really were three fields to hold information about degrees that instructors had earned. The data in each degree field looked something like: “MS in Computer Science, 1980, UC Santa Barbara.”

• Revise the class diagram to correct any problems that you find in this design. Then draw the relation scheme for your corrected model.