• Question 11 A(n) ____ is anything about which data are to be
collected and stored.
• Question 12 A verb associating two nouns in a business rule
translates to a(n) ____ in the data model.
• Question 13 A(n) ____ is a restriction placed on the data.
• Question 14 In the ____ model, the basic logical structure is
represented as an upside-down tree.
• Question 15 In the ____ model, the user perceives the database as a
collection of records in 1:M relationships, where each record can have
more than one parent.
• Question 16 A noun in a business rule translates to a(n) ____ in the
data model.
• Question 17 A(n) ____ join only returns matched records from the
tables that are being joined.
• Question 18 A ____ is any key that uniquely identifies each row.
• Question 19 The ____ constraint can be placed on a column to
ensure that every row in the table has a value for that column.
• Question 20 In an outer join, the matched pairs would be retained
and any unmatched values in the other table would be left ____.
• Question 21 ____ combines all rows from two tables, excluding
duplicate rows.
• Question 22 Since it is used to link the tables that originally were
related in a M:N relationship, the composite entity structure
includes—as foreign keys—at least the ____ keys of the tables that
are to be linked.
• Question 23 ____ yields only the rows that appear in both tables.
• Question 24 A(n) ____ is an ordered arrangement of keys and
pointers.
• Question 25 A ____ relationship exists when an association is
maintained within a single entity.
• Question 26 A ____ relationship exists when three entities are
associated.
• Question 27 A ____ identifier is composed of more than one
attribute.
• Question 28 A ____ should be a derived attribute.
• Question 29 If an entity can exist apart from one or more related
entities, it is said to be ____-independent.