Database Design and Windows Azure Data Storage - Cloud Database Development and Management - page 50

STUDENT STUDENT_CLASS CLASS CLASSROOM

ClassroomID
BuildingID
Capacity

StudentID ClassID

ClassID (FK)
StudentID (FK)
Grade

FirstName CourseID

TimeID
SemesterID
DayID

LastName

Major
FacultyID

CLASS_CLASSROOM

FACULT Y
FacultyID

CLASS_FACULTY
FacultyID (FK)
ClassID (FK)

BuildingID (FK)
ClassroomID (FK)
ClassID (FK)

FirstName

LastName
Department

Figure 2.19 Relationship of CLASS, STUDENT, FACULTY, and CLASSROOM.

he relationships that we have not deined are Time Block-Class, Semester-Class, and
Weekday-Class. heir deinitions are given in Figures 2.20 through 2.22. For each time
block, there can be many classes. To represent this nonidentifying relationship, we need the
attribute TimeID in the CLASS entity. Similarly, to represent the nonidentifying relation-
ship connecting CLASS and SEMESTER, we need the attribute SemesterID in CLASS.
he same is true for the nonidentifying relationship connecting CLASS and DAYS.

CLASS
ClassID
CourseID
SemesterID
TimeID (FK)

TIMEBLOCK
TimeID

TimeBlock

Figure 2.20 Relationship between TIMEBLOCK and CLASS.

CLASS
ClassID

SEMESTER
SemesterID

CourseID
SemesterID (FK)

SemesterName

Figure 2.21 Relationship between SEMESTER and CLASS.

CLASS
ClassID
CourseID (FK)
TimeID (FK)
SemesterID (FK)
DayID (FK)

DAYS

DayID

We ekDay

Figure 2.22 Relationship between DAYS and CLASS.