CIS 111 All Assignments CIS 111 All Assignments | Page 7

• Question 12 In the ____ model, the basic logical structure is represented as an upside-down
tree.
• Question 13 ____ are important because they help to ensure data integrity.
• Question 14 The ____ model is the end users’ view of the data environment.
• Question 15 A noun in a business rule translates to a(n) ____ in the data model.
• Question 16 A(n) ____ represents a particular type of object in the real world.
• Question 17 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 18 Referential ____ means that if the foreign key contains a value, that value refers
to an existing valid tuple (row) in another relation.
• Question 19 All primary key entries are unique, and no part of a primary key may be ____.
• Question 20 A ____ contains at least all of the attribute names and characteristics for each
table in the system.
• Question 21 In the context of a database table, the statement “A ____ B” indicates that if you
know the value of attribute A, you can look up the value of attribute B.
• Question 22 A(n) ____ is an ordered arrangement of keys and pointers.
• Question 23 In an outer join, the matched pairs would be retained and any unmatched values
in the other table would be left ____.
• Question 24 ____ combines all rows from two tables, excluding duplicate rows.
• Question 25 Another word for existence-independent is ____.
• Question 26 An entity is said to be ____-dependent if it can