Lab 2: Modifying a Database Design in Visio

Tiny-College-COURSE-and-CLASS-segment.vsd

text�

�

Table

COURSE

PK CRS_CODE CRS_TITLE CRS_DESCRIPTION CRS_CREDITS

CLASS

PK CLASS_CODE CLASS_SECTION CLASS_TIME FK1 CRS_CODE

STUDENT

PK STUD_ID STUD_FNAME STUD_LNAME STUD_TYPE

generates

enrolls

Business Rules: 1. One COURSE may generate many CLASSes. 2. Some COURSEs may not generate CLASSes 3. Each CLASS is generated by one COURSE. 4. Many STUDENTs may enroll in Many CLASSes. 5. No classes are offered on Sundays. 6. Classes may only be offered between 6:30 a.m. and 10:00 p.m.

GRADUATE

PK,FK1 STUD_ID GRAD_THESIS

UNDERGRADUATE

PK,FK1 STUD_ID UND_HOURS

STUD_ID

INSTRUCTOR

PK INST_ID INST_FNAME INST_LNAME INST__TITLE

enrolls

enrolls

enrolls