Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Multiple Choice Question. You can choose more than one option if you think. Please solve this for Database Management System. 1. What are the prime
Multiple Choice Question. You can choose more than one option if you think. Please solve this for Database Management System.
1. What are the prime attributes in the given relationship set? select all that applios: Consider relation R=(A,B,C,D). with the following FDs: AB -> C, C-> D, and D-> A. The candidate keys are: (A,B), (B, C), (B, D). 2. What are the non-prime attributes in the given relationship sel? select all that applies: Relation R=(A,B,C,D, E, F), with the following FDs: AB -> C, C-> D, and A-> F. The candidate keys are: (A,B), (B, C), (B, D). No N13 3. Based on the given relationship set and FD set in question 2. Does it hold partial dependency or full functional dependency? o parlial O full 4. Find if the given relationship set is in 2NF given: R = {A,B,C,D,E} FD = {AB->CD, C->A, D->E} AND candidate keys = AB, CB, AD Yes O NO 5. Which normal form is associated with the term 'transitive functional dependency INF 2NF 03NF BCNE 6. Given relation R-(A,B,C,D), find if Ris in 3NF with respect to the following FDs: 8 -> CC->AC->D(Bis the candidate key) OYS NoStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started