Click here to Skip to main content
15,867,488 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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
Posted
Updated 17-Mar-16 5:09am

We don't do your homework for you - it is set so that you can learn and cement the knowledge into your brain.

All of this should be covered in your course notes - or look here[^] for a reminder.
 
Share this answer
 
Follow these hints:
Assumption 1:
Hint 1:
Students can have more than one phone numbers; and there is one RA per dorm.

Assumption 2:
Hint 2:
One of the fields (attributes) has no relation to the student entity, in other words, it has no place in student table

Assumption 3:
Hint 3:
Similar to Hint 2.
 
Share this answer
 
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900