a) (5p) Suppose, you are given a relation R=(X, Y, Z, W, Q) with the following...

 

Transcribed Image Text:

a) (5p) Suppose, you are given a relation R=(X, Y, Z, W, Q) with the following functional dependencies: {YZ-XWQ, WY, Z-Q) Find the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF). Explain briefly. Normalize the relation just one level higher. b) (5p) Suppose, you are given a relation R = (X, Y, Z, W, Q) with the following functional dependencies: {ZQY, W-Z, X-Q} Identify the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF). Explain briefly. Normalize the relation just one level higher. c) (5p) Suppose, you are given a relation R = (A, B, C, D) with the following functional dependencies: (CD, CA, BDC) Identify the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF). Explain briefly. Normalize the relation just one level higher. a) (5p) Suppose, you are given a relation R=(X, Y, Z, W, Q) with the following functional dependencies: {YZ-XWQ, WY, Z-Q) Find the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF). Explain briefly. Normalize the relation just one level higher. b) (5p) Suppose, you are given a relation R = (X, Y, Z, W, Q) with the following functional dependencies: {ZQY, W-Z, X-Q} Identify the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF). Explain briefly. Normalize the relation just one level higher. c) (5p) Suppose, you are given a relation R = (A, B, C, D) with the following functional dependencies: (CD, CA, BDC) Identify the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF). Explain briefly. Normalize the relation just one level higher.