A relation is in 3 NF if it satisfies 2 NF and a. No non-prime attribute
Question:
A relation is in 3 NF if it satisfies 2 NF and …
a. No non-prime attribute type of R is transitively dependent on the primary key.
b. No prime attribute type of R is transitively dependent on the primary key.
c. No primary key of R is transitively dependent on a prime attribute type.
d. No non-primary key of R is transitively dependent on a prime attribute type.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
The correct answer is a No nonprime attribute type of R is transitively dependent on the primary key Heres a breakdown of the options a No nonprime at...View the full answer
Answered By
Nyron Beeput
I am an active educator and professional tutor with substantial experience in Biology and General Science. The past two years I have been tutoring online intensively with high school and college students. I have been teaching for four years and this experience has helped me to hone skills such as patience, dedication and flexibility. I work at the pace of my students and ensure that they understand.
My method of using real life examples that my students can relate to has helped them grasp concepts more readily. I also help students learn how to apply their knowledge and they appreciate that very much.
1+ Reviews
10+ Question Solved
Related Book For 
Principles Of Database Management The Practical Guide To Storing Managing And Analyzing Big And Small Data
ISBN: 9781107186125
1st Edition
Authors: Wilfried Lemahieu, Seppe Vanden Broucke, Bart Baesens
Question Posted:
