8. Functional determinant dependency is a constraint between two sets of attributes. A 1s the attribute on the left-hand side of the arrow in a functional . A de terminant could be: A) A candidate key B) Part of a composite key C) A non-key attribute D) All of the above E) A and B 9. The cardinality constraint A) Uniquely identifies entity instances B) Depends on the existence of another entity type c) specifies the nunber of instances of one entity that can (or must) be associated with each instance of another entity D) Is a rule that maintains consisteney among the rows of two relations E) None of the above 10. Some entities may have more than one candidate identifiers. If there is more than one candidate identifier, the designer must choose one of them as the identifier What would be the criterion or eriteria for selecting an identifier? A) Use intelligent identifiers, whose structure indicates classifications locations, etc. B) Choose an identifier such that for each instance of the entity, the attribute may or may not have valid values. C) Choose an identifier that will not change in value over the life of each instance of the entity type D) All of the above E) A and B 1. Host database nanipulations require locating zows that satisty one or more conditions. The use of indexes can greatly speed up the search process.Rule (s) for using indexes is (are): A) Use on smaller tables B) Index all columns of every table C) Use indexes heavily for non-volatile databases: limit the use of indexes for volatile databases D) Use indexes for fields with long values. E) Index every field that has less than 30 possible values 12. Customers submit orders. ordezs roquest products. In the Entity Relationahip model, Customers and Orders aze examples of A) Entities B) Relationships C) Attributes D) Descriptors E) Identifiers 13. You will likely see one or more foreign keys in A) An Entity Relationship diagram B) A Relational schema C) A Physical Schema D) A11 of the above E) Both options (B) and (C) 14. A relation that contains no multi-valued attributes and has non-key attributes that depend on part of the primary key is in which normal form? Fourth B) Second. C) Third. E) Fifth . Which type of file organization is most efficient with multiple key searches or retrievals? A) Hashed B) Clustered. C) Indexed