[CSCI3170]L3sol.docx

# [CSCI3170]L3sol.docx - CSCI3170 Classwork#L3 Name Student...

• Notes
• 2

This preview shows page 1 - 2 out of 2 pages.

abcd ab acd cd ac CSCI3170 Classwork (#L3) Name: Pass / Fail Student ID: 1. Consider the following relation and functional dependencies: R(a,b,c,d) F = {a b, c d} a) Give a BCNF decomposition of R. Please show your steps. Ans: Therefore, R(a,b,c,d) is decomposed into R 1 (a,b), R 2 (c,d) and R 3 (a,c) . b) Prove that your decomposition is a lossless-join decomposition. Ans: Consider the decomposition in two steps: Step 1: Decompose R(a,b,c,d) into R 1 (a,b) and R’(a,c,d) Since the common attribute between R 1 and R’ is a, and a is the key of R 1 , the decomposition is lossless-join. Step 2: Decompose R’(a,c,d) into R 2 (c,d) and R 3 (a,c) Since the common attribute between R

Subscribe to view the full document.

• Spring '19
• Database normalization, Abe, cd

{[ snackBarMessage ]}

###### "Before using Course Hero my grade was at 78%. By the end of the semester my grade was at 90%. I could not have done it without all the class material I found."
— Christopher R., University of Rhode Island '15, Course Hero Intern

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern