Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given R = { A , B , C , D , E } If AB > C , AB > D , A >

Given R={A,B,C,D,E}
If AB>C, AB>D, A>E,
Transforming the relation R to 3NF and identify the PKs for each resulting relation. Which is the correct transformation?
R1={A,B,C}, PK={A}
R2={A,B,D}, PK={A}
R3={A,E}, PK={A}
R1={A,B,C,D}, PK={A,B}
R2={A,E}, PK={A}
R1={A,B,C}, PK={A,B}
R2={A,B,D}, PK={A,D}
R3={A,E}, PK={A}
R1={A,B,C}, PK={A,B}
R2={A,B,D}, PK={A,B}
R3={A,E}, PK={A}

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

Advances In Knowledge Discovery In Databases

Authors: Animesh Adhikari, Jhimli Adhikari

1st Edition

3319132121, 9783319132129

More Books

Students also viewed these Databases questions