Insert anomaly means the inability to create a new record due to the absence of other data (2 points) True False 2 Specialization S: S = {V1, V2, ..., vn) is a set of subclasses with the same superclass G. If the union of v1, V2, ..., yn = G is correct all the time, then S is a total specialization. (2 Points) O True False Next Any shared subtype member must exist in all of its superclasses.* (2 Points) True False Trying to insert a value in a foreign key that references a primary key value that does not exist in the referenced relation is considered a violation of Referential integrity (2 Points) True False 5 In ER diagrams, derived attributes are depicted by double line oval shape * (2 Points) True False 6 Which of the following statements is NOT correct regarding data normalization: (2 Points) Controls data redundancy increases data duplication relations attributes Needs an understanding of functional depend 7 is a set of all valid values of an attribute! (2 Points) domain tuple Foreign Key 8 Which of the following is true? (2 points) Devery key is a superkey, but not every superkey is a key every superkey is a key, but not every key is a super key Every relation in BCNF is also in 3NF. * (2 Points) Yes, this is correct. , No, it is not correct. 10 Given a relation R (A, B, C, D, E, F, G, H, 1) which is in 3Nf. The primary key is a composite key of two attributes A and B. Which of the following functional dependencies must be FALSE? ***-- Select all that apply **** (2 Points) D--> B E --> A AD --> | A B --> C, D, E, F, G, H, I A--> F 11 Given a relation R R(A, F, G, H, I, J) where the primary key is a composite key of two attributes {A. I). Which of the following is a valid set of functional dependencies? (2 Points) O A--> GH, -->. HI --> F O A-> GIF ->J,H--> JF Both of the above are valid sets 12 Given the relation R, R(A, B, C, D, E, F, G, H ) and the following set of functional dependencies FDs: A B > C B --> EF AD --> GH G--> H -->) What is the key for R? (2 Points) O ABD O AO O ADG 13 Given the relation EXAM (P, Q, R, S, T, W) and the following set of functional dependencies FDs: P-->Q QR --> S T-->R S-->P Which of the following statements is correct? Select all that apply ------- *** PTW is a candidate key of relation EXAM STW is a candidate key of relation EXAM PTQ is a candidate key of EXAM No candidate keys in this relation 14 In R(K, L, M, N, O) and the following set of functional dependencies, FDs: 1-K--> L 2-K--> M 3- MN --> 0 4-L--> N 5.0 --> K Which of the following is correct? * (2 points) KM --> LM is not implied in the above set of functional dependencies. LN --> MN is not implied in the above set of functional dependencies. OLM--> MN is not implied in the above set of functional dependencies O--> L is not implied in the above set of functional dependencies