Is this schema in 3 normal form (relational database and normalization)

Question

PROFESSOR (ProfessorNetId, FirstName, LastName, Rank , DepartmentName(fk) )

STUDENT (StudentNetId , FirstName , LastName , IsGraduate, Major)

COURSE ( CourseId , CourseName ,DepartmentName(fk),Semester ,Year )

DEPARTMENT( Code ,Name,Chairman (fk))

Answer 1

Professor should have Department.Code istead of DepartmentName as the foreign key

Student should have some sort of academic code for the major instead of just the name

Course should have department.code instead of the department name

Course should have course # instead of courseName

Department should have employeeID or ProfessorNetid instead of chairman name

Any changes to the names of the department, course or professor will cause

inconsistences...

Here is the best mnueomic device, which is best remembered by the Oath of office

into which the witness is sworn for testimony during the court hearing...

"All of the data depends on the primary key <---- 1st NF

the WHOLE Primary key <----- 2nd NF

and nothing but the primary key <----- 3rd NF

so help me Codd