ZuoTi.Pro
Question

Given relation R(A, B, C, D, E, F), give (i) the key(s) of R and (ii)...

Given relation R(A, B, C, D, E, F), give

(i) the key(s) of R and

(ii) the normal form of R

if the FDs are:
(d) AB -> C, CD -> EF
(e) AB -> CD, D -> EF, C -> AB.
(f) ABC -> D, ABC -> E, ABC -> F.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

d):keys ABD

Normal form:1NF

e): keys. AB,CD

Normal form:1NF

f): keys:ABC

Normal form:1NFany queries plz comment

0 0
Add a comment
Know the answer?
Add Answer to:
Given relation R(A, B, C, D, E, F), give (i) the key(s) of R and (ii)...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Let R(A, B, C, D, E) be a relation wit FDs F = {AB->C, CD->E, E->B,...

    Let R(A, B, C, D, E) be a relation wit FDs F = {AB->C, CD->E, E->B, CE->A}.... Question 4 Not yet answered Marked out of 2.00 P Flag question Let R(A,B,C,D,E) be a relation with FDs F = {AB-C, CD-E, E-B, CE-A} Consider an instance of this relation that only contains the tuple (1, 1, 2, 2, 3). Which of the following tuples can be inserted into this relation without violating the FD's? (2 points) Select one: 0 (0, 1,...

  • For the following relations and set of FDs: 1. give a key for the relation; 2....

    For the following relations and set of FDs: 1. give a key for the relation; 2. state whether the relation is in BCNF, and if it is not state why: 3. give a set of relations in 3NF equivalent to the original relation 1. (33 points) What is the closure of (A,B) with respect to R(A,B,C,D,E,F,G)if R has the following functional dependencies? (a) GCDE AF BF - ABC FC G (b) D-AC-D A+B ABC 2 33 points for each of...

  • Given the following relation schemas and the sets of FD's: a- R(A,B,C,D) F={ABẠC,C7D, D´A, BC+C} b-...

    Given the following relation schemas and the sets of FD's: a- R(A,B,C,D) F={ABẠC,C7D, D´A, BC+C} b- R(A,B,C,D) F={BẠC, BD, AD>B} C- R(A,B,C,D) F={AB-C, DC+D, CD+A, AD+B} d- R(A,B,C,D) F={AB=C, C+D, D™B, DE} e- R(A, B, C, D, E) F= {AB+C, DB+E, AE>B, CD+A, ECD} In each case, (i) Give all candidate keys (ii) Indicate the BCNF violation Give the minimal cover and decompose R into a collection of relations that are BCNF. Is it lossless? Does it preserve the dependencies?...

  • Let R(A,B,C,D,E) be a relation with FDs F = {AB-CD, A-E, C-D, D-E} The decomposition of...

    Let R(A,B,C,D,E) be a relation with FDs F = {AB-CD, A-E, C-D, D-E} The decomposition of Rinto R1(A, B, C), R2(B, C, D) and R3(C, D, E) is 2 Points) Select one: Lossless and Dependency Preserving. Lossy and Not Dependency Preserving. Lossless and Not Dependency Preserving. Lossy and Dependency Preserving.

  • Let R(A,B,C,D,E) be a relation with FDs F = {AB-CD, A-E, C-D, D-E} The decomposition of...

    Let R(A,B,C,D,E) be a relation with FDs F = {AB-CD, A-E, C-D, D-E} The decomposition of Rinto R1(A, B, C), R2(B, C, D) and R3(C, D, E) is 2 Points) Select one: Lossless and Dependency Preserving. Lossy and Not Dependency Preserving. Lossless and Not Dependency Preserving. Lossy and Dependency Preserving.

  • Let R(A,B,C,D,E) be a relation with FDs F = {AB-CD, A-E, C-D, DE} The decomposition of...

    Let R(A,B,C,D,E) be a relation with FDs F = {AB-CD, A-E, C-D, DE} The decomposition of R into R1(A, B, C), R2(B, C, D) and R3(C, D, E) is (2 Points) Select one: Lossy and Dependency Preserving. Lossless and Not Dependency Preserving. Lossy and Not Dependency Preserving. Lossless and Dependency Preserving.

  • Let R(A,B,C,D,E) be a relation with FDs F = {AB-C, CD-E, E–B} (2 Points) Select one:...

    Let R(A,B,C,D,E) be a relation with FDs F = {AB-C, CD-E, E–B} (2 Points) Select one: O Ris in 3NF but not in BCNF. O Ris not in 3NF but in BCNF. O Ris in 3NF and in BCNF. R is not in 3NF and not in BCNF.

  • Here's a relation (R), its attributes and its functional dependencies (F): R(A, B, C, D, E)...

    Here's a relation (R), its attributes and its functional dependencies (F): R(A, B, C, D, E) C D → B A → D D → C E → C What is the closure of AB ({AB}+)? What is the closure of F (F+)? [ set of closures for all LHS][each LHS on one line] What is the minimal set (cover) for F? Provide a key for relation R (a minimal set of attributes that can determine all attr.) Decompose the...

  • Let R(A,B,C,D,E) be a relation with FDs F = {AB-C, CD-E, E-B, CE-A} Consider an instance...

    Let R(A,B,C,D,E) be a relation with FDs F = {AB-C, CD-E, E-B, CE-A} Consider an instance of this relation that only contains the tuple (1, 1, 2, 2, 3). Which of the following tuples can be inserted into this relation without violating the FD's? (2 points) Select one: O (0, 1, 2, 4,3) (1,1,2,2,4) (1.2.2, 2, 3) o (1,1,3,2,3) All of the above can be inserted. None of the above can be inserted.

  • my choices for these are wrong. 10 points QUESTION 3 Given R=(A, B, C) is a...

    my choices for these are wrong. 10 points QUESTION 3 Given R=(A, B, C) is a schema and F = {2C-A AB) is a set of FDs that hold on R. Which of the following statements is not true? d=(AB. AC) is a decomposition of that is in BCNF. O Ris in 3NF O BC is a candidate key for R Ris in BCN 10 points QUESTION 4 Given R= (A. 3. CD. E) is a schema and F= (A...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT