DEPARTMENTS
deptCodePK
deptName
OfficeNumber
DisplayOrder PROGRAMS
progCodePK
progName
lengthYears
isCurrent
deptCodeFK
COURSES
courseCodePK
CourseName
isAvailable
field
STUDENTS
studentIDPK
FirstName
LastName
DOB
Gender
Phone
advisorIDFK
EMPLOYEES
empIDPK
FirstName
LastName
Prefix
Suffix
isActive
SIN
DOB
ADVISORS
empIDPK,FK
isActivePROFESSORS
empIDPK,FK
deptCodeFK
isActive
JNC_PROG_COURSES
progCodePK,FK
courseCodePK,FK
isActive
JNC_PROG_STUDENTS
progCodePK,FK
studentIDPK,FK
isActive
JNC_STUDENTS_SECTION
sectCodePK,FK
studentIDPK,FK
isActive
DBS211 – Lab 06 ERDs,
Solutions
Clint MacDonald
SECTIONS
sectCodePK
SectName
profIDFK
courseCodeFK
termCode
PHONES
phoneIDPK
phoneNumberFK
phoneType
empIDFK