DBMS
1 Answer
DBMS
| Flag | PURGE
Question Number 1
Consider a table "Student" consisting of columns (Student ID, Student Address, Course).
Every student is allowed to enroll in multiple courses and every course is allowed to enroll more than one student. Also every time a student changes address, all his relevant records must be changed to reflect the new address.
What would be the Normal form required to avoid this redundancy?
2nd NF
4th NF
3rd NF
1st NF
Email me when people comment.
Email me when people comment.
Loading...
An error occurred in subscribing you.
Email me when people comment.
Email me when people comment.
Loading...
An error occurred in subscribing you.
CareerCup is the world's biggest and best source for software engineering interview preparation. See all our resources.
2nd NF would avoid this redundancy.
- manispatel005 July 23, 2012In 2 NF, every non-key attribute is fully dependent on each candidate key of R . So the Relation gets broken down as :R1( Student ID, Student Addr) and R2(Student Id,Course).
So now to update address just update relation 1.