CIS 111 All Assignments CIS 111 All Assignments | Page 11

•
Question 39 A ____ exists when there are functional dependencies such that Y is
functionally dependent on X and Z is functionally dependent on Y, and X is the primary key.
•
Question 40 A relational table must not contain a(n) ____.
Set 5
•
Question 1 A(n) ____ database supports a relatively small number of users (usually
fewer than 50) or a specific department wit hin an organization.
•
Question 2 A(n) ____ database is designed to support a company’s day-to-day
operations.
•
Question 3 ____ provide(s) a description of the data characteristics and the set of
relationships that link the data found within the database.
• Question 4 The response of the DBMS to a query is the ____.
• Question 5 A workgroup database is a(n)____ database.
•
Question 6 The ____ structure is quite different from that of an operational or
transactional database.
• Question 7 ____ is used to reveal the meaning of data.
• Question 8 A desktop database is a ____ database.
•
Question 9 A verb associating two nouns in a business rule translates to a(n) ____ in the
data model.
•
Question 10 A(n) ____ is anything about which data are to be collected and stored.
•
Question 11 In the ____ model, the basic logical structure is represented as an upside-
down tree.
• Question 12 A(n) ____ enables a database administrator to define schema components.
• Question 13 A(n) ____ represents a particular type of object in the real world.
• Question 14 The ____ model is the end users’ view of the data environment.