CIS 111 All Assignments CIS 111 All Assignments | Página 2

•
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.
•
Question 30 An entity is said to be ____-dependent if it can exist in the database only
when it is associated with another related entity occurrence.