Discuss the normal forms for a relational database schema. The relational schema given below is in First normal form stores data about student who got allocated in the university hostel: UniHostel (StudentID, HostelID, Stud.Name, Hostel Name, Number of_Rooms, Room Type, Date.of_Birth, Year_Enrolled, Semester, Rent, Hostel Location, Teacher Name, TeacherID, Caretaker, Duration) The following functional dependencies between the attribute exist and should be preserved during normalization (dependency preserving): StudentID, HostellD - Rent. Room-Type StudentID- Stud Name, Date of Birth, Year Enrolled, Semester HostelID- Hostel_Name, Hostel Location, Number of.Rooms, Teacher_Name, TeacherID, Caretaker TeacherID - Teacher Name starting from UniHostel - Ceate a schema in 2nd normal form while respecting the functional dependencies. Transform the resulting schema into 3rd normal form. Identify primary keys by underlining.

Note: I need an answer in regarding to DBMS. Using functional dependencies and preserving them we must solve this question into second normal form and third normal form. Also, underline the primary keys.