Quiz3_Omiecinski - CS 4400- SPRING 2007...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
CS 4400- SPRING 2007 (Navathe/Omiecinski) Quiz #3 Name (Please Print): ____________________________________________ GTID: __________________________________________________ 1. (a) (b) (c) (d) 2. (a) (b) (c) (d) 3. (a) (b) (c) (d) 4. (a) (b) (c) (d) 5. (a) (b) (c) (d) 6. (a) (b) (c) (d) 7. (a) (b) (c) (d) 8. (a) (b) (c) (d) 9. (a) (b) (c) (d) 10. (a) (b) (c) (d) 11. (a) (b) (c) (d) 12. (a) (b) (c) (d) 13. (a) (b) (c) (d) 14. (a) (b) (c) (d) 15. (a) (b) (c) (d) 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) Quiz3_Spring’07 Page 1 Navathe
Background image of page 1

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

View Full DocumentRight Arrow Icon
NAME (PLEASE PRINT)------------------------------------ GTID # ----------------- CS 4400- Spring 2007 - Quiz #3 1. By mapping the ER diagram in the figure below, the resulting correct set of relations is the following: (a) E1(A, B, C), E2(C, D, A), RS (A,C,G,H) (b ) E1(A, B, C, H), E2(C, D) R( A, C, G) (c) E1(A, B), R(A, C, G), E2(C, D), S(C, H) (d) E1(A, B, C,H), E2(C, D, G) 2. The best mapping for the following ER diagram results in the relations a) Employee(SSN , Child,StartDate) and Project(PID ,City) b) Employee(SSN ), Employee_Child(SSN,Child ), and Project(PID ,City,StartDate) c) Employee(SSN,Child ), Project(PID ,City,StartDate) and Works(SSN,PID ) d) Employee_Child( SSN,Child ), Employee_Works( SSN ,PID,StartDate) and Project( PID ,City) 3. In the relations resulting from translating the EER diagram in this Figure, the key of the relation corresponding to entity type F is: a) {A, D, G } b) {A, G, H } c) { A, G } d) {A, B, D, G } Quiz3_Spring’07 Page 2 Navathe S R A E 1 E 2 M N 1 N B C D G H Child 1 N Work SSN Employee Project PID City StartDate E B F H G A d E1 E2 D C
Background image of page 2
4. In the translation of the EER diagram in Figure 4, relation W is: a) W (A , B, D) b) W (A ,D) c) W ( A,B , D) d) W (B , D) 5. Consider the generalization hierarchy where EMPLOYEE is exhaustively classified into three subclasses PROGRAMMER, MGR, SECR . Which of the following describes how to represent the EMPLOYEE hierarchy? a) We can have 4 relations, one for each entity type, all with SSN as key b) We can set up 3 relations, each with key SSN and preserve all information by propagating the inherited attributes SSN, DOB into the subclass relations c) We can set up a single relation EMPLOYEE (SSN , DOB, Language, Grade, Education, Type): where Type will take care of the one or more subclasses to which the Employee belongs d) All (or any) of the above options Quiz3_Spring’07 Page 3 Navathe EMPLOYEE O SECR MGR PROGRAMMAR Languag e Grade Education DOB SSN d A C D B R S W T
Background image of page 3

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

View Full DocumentRight Arrow Icon
6. When we map an n-ary relationship (where n > 2) from the ER Model to the relational model
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/29/2009 for the course CS 4400 taught by Professor Marks during the Spring '07 term at Georgia Institute of Technology.

Page1 / 10

Quiz3_Omiecinski - CS 4400- SPRING 2007...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online