(1NF)
STUDENT(STU_NUM, STU_LNAME, STU_MAJOR, DEPT_CODE, DEPT_NAME, DEPT_PHONE, COLLEGE_NAME, ADVISOR_LNAME, ADVISOR_OFFICE, ADVISOR_BLDG, ADVISOR_PHONE, STU_GPA, STU_HOURS, STU_CLASS)

VERSION I  (2NF)
STUDENT(STU_NUM, STU_LNAME, STU_MAJOR, DEPT_CODE, ADVISOR_LNAME,
STU_GPA, STU_HOURS, STU_CLASS)

DEPARTMENT(DEPT_CODE, DEPT_NAME, DEPT_PHONE, COLLEGE_NAME)

ADVISOR(ADVISOR_LNAME, ADVISOR_OFFICE, ADVISOR_BLDG, ADVISOR_PHONE)

VERSION II (3NF)
STUDENT(STU_NUM, STU_LNAME, STU_MAJOR, DEPT_CODE, ADVISOR_LNAME,
STU_GPA, STU_HOURS, STU_CLASS)

DEPARTMENT(DEPT_CODE, DEPT_NAME, DEPT_PHONE, COLLEGE_NAME)

ADVISOR(ADVISOR_LNAME, ADVISOR_OFFICE, ADVISOR_PHONE)

OFFICE(ADVISOR_OFFICE, ADVISOR_BLDG)

VERSION III
STUDENT(STU_NUM, STU_LNAME, STU_MAJOR, DEPT_CODE, ADV_NUM,
STU_GPA, STU_HOURS, STU_CLASS)

DEPARTMENT(DEPT_CODE, DEPT_NAME, DEPT_PHONE, COLLEGE_CODE)

COLLEGE(COLLEGE_CODE, COLLEGE_NAME, ……)

ADVISOR(ADV_NUM , ADVISOR_LNAME, OFFICE_NUM, ADVISOR_PHONE, …..)

OFFICE(OFFICE_NUM , OFFICE_NAME, BLDG_NUM)

BULIDING(BLDG_NUM, BLDG_NAME, …. )

OR ERD as follows