CIS 111 All Assignments CIS 111 All Assignments | Page 10

•
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 A(n) ____ join only returns matched records from the tables that are being
joined.
•
Question 24 In an outer join, the matched pairs would be retained and any unmatched
values in the other table would be left ____.
•
Question 25 A ____ identifier is composed of more than one attribute.
•
Question 26 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 27 Another word for existence-independent is ____.
•
Question 28 A ____ relationship exists when an association is maintained within a single
entity.
•
Question 29 Knowing the ____ number of entity occurrences is very helpful at the
application software level.
• Question 30 A ____ relationship exists when three entities are associated.
• Question 31 A ____ should be a derived attribute.
• Question 32 Ideally, an entity identifier is composed of ____ attribute(s).
• Question 33 An atomic attribute ____.
•
Question 34 A table that is in 2NF and contains no transitive dependencies is said to be
in ____.
•
Question 35 ____ databases reflect the ever-growing demand for greater scope and
depth in the data on which decision support systems increasingly rely.
•
Question 36 A table that displays data redundancies yields ____.
•
Question 37 A table that has all key attributes defined, has no repeating groups, and all
its attributes are dependent on the primary key, is said to be in ____.
•
Question 38 Normalization represents a micro view of the ____ within the ERD.