1
6.5kviews
For the following dependencies find the candidate keys.

For the following dependencies find the candidate keys. A={ P,Q,R,S,T } P->QR , Q->S , RS->T, R->S Is the following decomposition a lossless join? 1. R1 = {P,Q,R}, R2 ={P,S,T} 2. R1={P,Q,R} R2={R,S,T}

1 Answer
2
326views

Relational Schema A = {P,Q,R,S,T}

The Functional Dependencies =

$P → QR$

$Q → S$

$RS → T$

$R → S$

The Decomposition of Relation A =

1] R1 = {P, Q, R}, R2 = {P, S, T}

2] R1 = {P, Q, R}, R2 = {R, S, T}


Candidate …

Create a free account to keep reading this post.

and 2 others joined a min ago.

Please log in to add an answer.