Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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 No

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Database Programming With Visual C# .NET

Authors: Ying Bai

1st Edition

0470467274, 978-0470467275

More Books

Students also viewed these Databases questions

Question

=+ For what reasons can and do unions go on strike?

Answered: 1 week ago

Question

=+ Is secondary industrial action common and/or legal?

Answered: 1 week ago