PK

FK

EMPLOYEE

Employee ID

Last$\_$Name

First Name

Employee$\_$Type

Date$\_$ Hired

Email$\_$Address

Academic$\_$Progarm$\_$ID

PK

FK

FK

STUDENT

CBU ID

Student$\_$Name

Enroll$\_$Date

Student$\_$Email

Academic$\_$Program$\_$ID

Academic$\_$Advisor$\_$ID

$$

PK

ROOM

Room ID

Seating$\_$Capacity.

NUFLEX$\_$Capable

ACADEMIC PROGRAM

$$ PK

Academic Program ID

Program$\_$Name

Program$\_$Description

ENROLLMENT

$$

PK$,$ FK$1$

$$K$,$FK$2$

CBU ID

Class Section

Grade

PK

FK

PROFESSOR

Professor ID

Tenured

Employee$\_$ID

H PK

FK

PK$,$FK$1$

PK

FK

FK

ACADEMIC ADVISOR

Academic Advisor ID

Name

Email

Program$\_$ID

Employee$\_$ID

CLASS

Course ID

Class Section

Class$\_$Time

Professor$\_$ID

Room$\_$ID

PK

FK

COURSE

Course ID

Description

Credit

Academic$\_$Program$\_$ID