Course Hero Logo

To generate a surrogate key microsoft access uses an

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 38 - 41 out of 616 pages.

176.To generate a surrogate key, Microsoft Access uses a(n) _____ data type.a.Identityb.AutoNumber
c.Sequenced.CharacterAnswer:AutoNumber177.Granularity refers to _____.
178.From a structural point of view, 2NF is better than _____.
179.A table is in 4NF if it is in 3NF, and _____.
180.In a _____ situation, one key determines multiple values of two other attributes andthose attributes are independent of each other. a.Multivalued dependencyb.Partial dependencyc.Functional dependencyd.Transitive dependencyAnswer:Multivalued dependency
181.From a system functionality point of view, _____ attribute values can be calculatedwhen they are needed to write reports or invoices.
182.Improving _____ leads to more flexible queries.
183.When a table contains only one candidate key, _____ are considered to be equivalent.
184.A(n) _____ exists when there are functional dependencies such that Y is functionallydependent on X, Z is functionally dependent on Y, and X is the primary key. a.transitivedependencyb.partial dependencyc.repeating groupd.atomic attributeAnswer:transitive dependency
185.The SQL data manipulation command HAVING:

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 616 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Oyedate Emmanual
Tags
administrator

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture