Question: 5. Given a valid instance of a relational schema Friends with three attributes (X, Y, Z), containing the tuples: (monica, 216, 657), (ross, 216,

5. Given a valid instance of a relational schema Friends with three

5. Given a valid instance of a relational schema Friends with three attributes (X, Y, Z), containing the tuples: (monica, 216, 657), (ross, 216, 657), and (phoebe, 657, 657), (chandler, 657, 216). Specify whether each of the following functional dependencies holds over Friends: a. XY b. XZ Y c. XY Z d. YZ X 6. Given a relation R(A, B, C, D, E, F) and a set of functional dependencies F = {AB, BC, ABD, EFA}: a. List 3 super keys for R b. List all candidate keys for R c. List all possible primary keys for R d. List all normal forms that R satisfies

Step by Step Solution

3.41 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Problem 5 Given a relational schema Friends with tuples monica 216 657 ross 216 657 phoebe 657 657 c... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!