CS351: Database Design

Exam 3 Case

This is an exam. All work is to be completed individually, without discussion with or help from your classmates. The exam is due at 11:40am, Tuesday, 17 October, 1998. Exams may be hand-delivered to either of my offices (SAC 284 or CSTC 500) by that time, e-mailed by that time, or faxed to 773.325.7167. Exams may be handwritten/hand-drawn, or may be computer generated. I can read Visio 5.0 files, GIF, JPEG, HTML, and Word files. Questions about the exam should be mailed directly to me at: lsadler@mail.depaul.edu.

In the School of Computer Science, Telecommunications, and Information Systems, all students are assigned to a faculty advisor upon matriculation. Faculty advisors are responsible for assisting students with schedule and course planning, career planning, and life. Faculty advising appointments are most often made by the front desk in the CTI main office. Because the School is growing so quickly, it has become necessary to develop a database that will:

1. House faculty pre-set advising hours each quarter (e.g., MW, 2-4pm). These will change each quarter.
2. Store students assigned to each faculty member
3. Log appointments made for each student with the faculty member so that:

• The Dean can see how many student advising appointments a given faculty member has had during a given period of time (month, 3 months, year, etc.)
• A staff advisor can see how many times a given student has seen his/her advisor during a given period of time (month, 3 months, year, etc.)

1. Track student requests to change advisors (e.g., from Johnsonbough to Kalin)
2. Track advisee load for each faculty member (e.g., # of students assigned to faculty)
3. Track advising areas for each faculty member (e.g., CS, HCI, TDC, etc.)
4. Trigger a request for the student file to be pulled and placed in the faculty mailbox 24 hours before the scheduled appointment when an appointment is made.
5. Provide comment space for faculty to enter advising notes for each student.
6. Trigger an e-mail note to the faculty with appointment information for each appointment that is created.