A database is an organized collection of related data

1. A database is an organized collection of ________ related data.
A) logically
B) physically
C) loosely
D) badly
2. Program-data dependence is caused by:
3. Because applications are often developed independently in file processing systems:
4. Relational databases establish the relationships between entities by means of common
fields included in a structure called a/an:

3
5. The following figure shows a:
A) disjoint constraint.
B) completeness constraint.
C) supertype/subtype hierarchy.
D) spindle constraint.
6. A/an ________ is the relationship between a weak entity type and its owner.
7. A property or characteristic of an entity type that is of interest to the organization is
called a/an:

4
8. A nonkey attribute is also called a/an:
9. When a regular entity type contains a multivalued attribute, one must:
A) create a single relation with multiple lines for each instance of the multivalued
attribute.
B) create two new relations, one containing the multivalued attribute.
C) create two new relations, both containing the multivalued attribute.
D) delete the relation and start over.
10. In the figure below, what type of relationship do the relations depict?

5
11. In the figure below, which of the following apply to both OUTPATIENTs and
RESIDENT_PATIENTs?
12. A ________ is a temporary table used in the FROM clause of an SQL query.
13. Embedded SQL consists of:
A) hard-coded SQL statements included in a program written in another language.
B) SQL encapsulated inside of other SQL statements.
C) SQL written into a front-end application.
D) SQL translated to a lower-level language.