Question: The relational schema given below in is normal form stores data about student who got allocated in the university hostel: UniHostel (StudentID, HostelID, Stud.Name, Hostel
The relational schema given below in is 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 nor- malization (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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
