{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Quiz4_Navathe

# Quiz4_Navathe - NAME GT ID CS 4400 A(NAVATHE QUIZ 4 Spring...

This preview shows pages 1–3. Sign up to view the full content.

NAME:_______________________________ GT ID:_______________ CS 4400 A (NAVATHE) QUIZ 4 Spring 2007 1. A B C D 2. A B C D 3. A B 4. A B C D 5. A B C D 6. A B C D 7. A B 8. A B C D 9. A B C D 10. A B 11. A B 12. A B C D 13. A B C D 14. A B C D 15. A B 16. A B C D 17. A B C D 18. A B C D 19. A B C D 20. A B C D CS 4400 – Quiz 4 Page 1 Navathe (Sec A)

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
GT ID:_____________________ QUIZ 4 CS 4400 A (Navathe) Spring 2007 In problems 1 through 3, consider the set of attributes {A, C, D, E, H} in relation R and the two sets of functional dependencies: F = {A→C, AC→D, E→AD, E→H} and G = {A→CD, E→AH}. 1. Which is a key of R according to F? a) A b) AH c) E d) CD 2. What is {A} + computed with respect to F? a) {A} b) {A, C} c) {A, C, D} d) {A, C, D, E} 3. Are the sets F and G equivalent? a) No b) Yes For questions 4 through 15, consider the relational schema Book_adopt (instructor, course, book, semester, inst_office, credits, no_exams) and the set of functional dependencies F = {instructor→ inst_office, course,semester→book, semester →no_exams course→credits, course,semester→instructor}. NOTE:
This is the end of the preview. Sign up to access the rest of the document.
• Spring '07
• Marks
• Databases, Relational model, Database normalization, Seek time, B B B B B B B B B B B B B B B B B B B C C C C C D D D D D C C C D D D C C D D C C C D D D C C D D, Book_adopt schema

{[ snackBarMessage ]}

### Page1 / 5

Quiz4_Navathe - NAME GT ID CS 4400 A(NAVATHE QUIZ 4 Spring...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online