Database Reference
In-Depth Information
COLLEGE
DEPARTMENT
DepartmentName
Chairperson
Phone
TotalMajors
Building
Room
PROFESSOR
COLLEGE
DEPARTMENT
DepartmentName
Chairperson
Phone
TotalMajors
Building
Room
PROFESSOR
CollegeName
DeanName
Phone
Building
Room
ProfessorName
Building
OfficeNumber
Phone
CollegeName
DeanName
Phone
Building
Room
ProfessorName
Building
OfficeNumber
Phone
(a) Data Model Using an N:M Relationship
(b) Data Model Using a 1:N Relationship
DEPARTMENT
DepartmentName
Chairperson
Phone
TotalMajors
Building
Room
DEPARTMENT
DepartmentName
Phone
TotalMajors
Building
Room
COLLEGE
PROFESSOR
COLLEGE
PROFESSOR
CollegeName
DeanName
Phone
Building
Room
ProfessorName
Building
OfficeNumber
Phone
CollegeName
DeanName
Phone
Building
Room
ProfessorName
Building
OfficeNumber
Phone
Chairs/Chaired By
APPOINTMENT
APPOINTMENT
Title
Terms
Title
Terms
(c) Data Model Using an Association Pattern
(d) Data Model Using an Association Pattern
and 1:1 Relationship
Figure 5-47
Alternate Data Models for the DEPARTMENT-to-PROFESSOR Relationship
 
Search WWH ::




Custom Search