CIS 111 Study Career Begins/cis 111mart.com CIS 111 Study Career Begins/cis 111mart.com | Page 3

• 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 .
• Question 31 A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship .