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:
• 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.
Copyright © 2002–2006, by Tom Jewett. Links to this site are welcome and encouraged. Individual copies may be printed for non-commercial classroom or personal use; however, this material may not be reposted to other web sites or newsgroups, or included in any printed or electronic publication, whether modified or not, without specific permission from the author.