Convert this relation to 3NF and represent the design using the alternative description method.
♥ 0 |
Suppose you have a table for a tutoring service. The fields are the student’s identification number, student’s name, student’s telephone number, student’s email address, tutoring session identification number, tutoring session meeting day, tutoring session meeting time, name of tutor, and tutor identification number. Assume that each student has one tutoring session, each tutoring session meets only once a week and has one tutor, and each tutor can teach more than one class. In what normal form is the table, given the following alternative description? Student (StudentID, StudentName, StudentPhone, StudentEmail, SessionID, SessionDay, SessionTime, TutorName, TutorID) Convert this relation to 3NF and represent the design using the alternative description method. |
Explanation
Conversion into third normal form
In the third normal form, determinant part should be candidate key. Transitive and partial dependencies are avoided in the third normal form.
The alternative description of 3NF relations is
Session(SessionID, SessionDay, SessionTime,)
Tutor(TutorName, TutorID)
Student(StudentID, StudentName, StudentPhone, StudentEmail, SessionID, TutorID)
Foreign Key :-SessioniD to Session table
Foreign Key :-TutoriD to Tutor table
These are all three tables which doesn't have anomalies.
Verified Answer
Student table is having a primary key Studentid. So the table is currently in the second normal form. The SudentiD field is determinant for the SessionID, SessionDay, SessionTime, TutorName, TutorID. Table is converted into third normal form.
The Best Research Paper Writing Service
Would you want to pay someone to write your paper professionally from scratch? 100% Original and 0% AI Content!.