1. Please translate the following table into the third normal form (3NF) using the format of the provided example. You may add new tables and fields to accomplish this.

Problem table (non-normalized):

Student (StudentName, StudentAddress, DateofBirth, Gender, StudentPhoneNumber, ClassYear, AdvisorName, AdvisorPhoneNumber, AdvisorBuilding, AdvisorOfficeNumber, CarManufacturer, CarModel, CarYear, PlateNumber)

An example table (non-normalized):

Course (DepartmentName, DepartmentOffice, ChairName, CourseName, CreditHours, ClassSection, ClassTime, ClassRoom, ProfessorName)

Correct 3NF translation from example table:

Course (CourseID, DepartmentID, CourseName, CreditHours)

FK: DepartmentID references Department

Department (DepartmentID, DepartmentName, DepartmentOffice, ChairName)

Class (ClassID, CourseID, Section, ClassTime, Room, ProfessorID)

FK: CourseID references Course

FK: ProfessorID references Professor

Professor (ProfessorID, LastName, FirstName, Rank)