Assigned: 4 October 2005
Due: 13 October 2005
To schedule classes your school needs to know about courses that can be offered, instructors and their availability, equipment requirements for courses, and rooms (and their equipment). From the courses that can be scheduled, the schedulers select the courses that will be scheduled. For each of these courses, they schedule one or more sections. The schedulers must assign classes to instructors, rooms, and time slots. The schedulers are constrained by the reality that (1) some courses cannot conflict because many students take them during the same term, (2) the instructor cannot be in two places at the same time, and (3) rooms cannot be double-booked.
Construct a data model to help the schedulers. Specifically, construct a context level data model, and then expand that to include attributes and primary keys. Clearly state any reasonable assumptions.
To facilitate a more concrete understanding of the relationships between the entities, you might find it useful to examine the classes scheduled in the BSA building. Appendix A lists the codes that are used to indicate the type of equipment that may be requested by the instructor for a course.
(BLANK) - Unidentified
AIR - Air for Lab
AS - Auditorium seating w/o tablets
AST - Auditorium seating with tablets
AUD - Audio system
CES - Computer at each station
CHK - Chalkboard
CIS - Computer at Instructor Station
CI2 – Computer Instruction Station, Ceiling Mounted Projector, and Screen
CI3 - Computer at Instructor Station & Internet
CMP - Ceiling mounted projector
CM2 - Ceiling Mounted Projector, and Screen & Room Blinds
DIS - Distilled water
DL - Distance learning capability
DT - Drafting tables
DVD - DVD
DV2 - DVD and Monitor
DV3 - DVD and TV
DV4 - DVD, TV and VCR
ELM - Document Camera - ELMO
EP2 - ELMO and Ceiling Mounted Projector
FTC - Fixed tables & chairs
GAS - Gas for Lab
HOD - Hoods
INT - Internet for Instructor
LPP - Student Laptop Power & Internet Connectivity
MON - Monitor
MO2 - VCR and Monitor
MTC - Movable tables & chairs
PIA - Piano
PRJ - Overhead Projector
PR2 - Overhead Projector and Screen & Room Blinds
PS - Projector screen
RDB - Room darkening blinds
SB - Smart Board
SPC - Seminar w/perimeter PC's
STA - Stage
STC - Seminar table & chairs
TAC - Tablet-arm chairs
TV - Television
TV2 - TV and Monitor
TV3 - TV and VCR
VCR - VCR
VTL - Cameras & Mic (V-TEL)
WAT - Water for Lab
WTB - Whiteboard
WN - Wireless Network
ZNP - No preferences
ADF*- AV - Double Fixed Screen
ASF*- AV - Single Fixed Screen
CBL*- Chalkboard - Large
CBM*- Chalkboard - Medium
CBS*- Chalkboard - Small
COM*- Computers
CPT*- Carpeting
LAB*- Lab: specialized
LAN*- Language Lab Equipment
POD*- Podium
RST*- Raised Stages
SND*- Sound Isolated Booths
TVC*- TV Cable Hookup