1. Assumptions: The student_id is the primary key. Students can have more than one phone number but only one major. There is one RA per dorm; ‘dorm’ is the name of the student’s dormatory and is unique.
Student (student_id, dorm, phone, major, RA)
2. Assumptions: The student_id is the primary key. Students can have only one advisor. You may assume the advisor names are a unique identifier. Each advisor is associated with exactly one department.
Student (student_id, advisor_name, advisor_dept)
3. Assume these dependencies exist:
type --> price
author --> author_affiliation
Book (author, title, type, price, publisher, author_affiliation)
What I have tried:
I am struggling to indentify which normal form are they.
and process in converting to 3nf