Convert this relation to 3NF and represent the design using the alternative description method.

Convert this relation to 3NF and represent the design using the alternative description method.

March 23, 2022
15 Views
0
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.

Answer and ExplanationSolution by a verified expert

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.

Purchase this answer to view it.
Click the button to login/signup and buy full solution at 2 USD only.

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!.

🎓 Write my Essay
📚 Write my Persuasive Essay
📋 Humanize AI Content for Turnitin
💻 Write my Reflective Essay
📑 Write my Research Paper
📜 Write my Thesis Paper
📘 Write my Dissertation
📋 Write my Case Study
📝 Write my Online Exam
✒️ Write my Term Paper
Write my Paper