- Description
- Full Document
University of Phoenix
Advanced Database Architecture (DAT 380)
a _____ relationship exists when an association is maintained within a single entity.
1. In a database context, the word _____ indicates the use of the same attribute name to label
different attributes
2. If Tiny College has some departments that are classified as “research only” and do not offer
courses, the COURSE entity of the college database would be _____ the DEPARTMENT entity.
3. The decision to store _____ attributes in database tables depends on the processing
requirements and the constraints placed on a particular application.
4. When the specific cardinalities are not included on the diagram in Crow’s Foot notation,
cardinality is implied by the use of _____.
5. A(n) _____ is an orderly arrangement used to logically access rows in a table.
6. A _____ is the primary key of one table that has been placed into another table to create a
common attribute.
7. The one-to-many (1:M) relationship is easily implemented in the relational model by putting the
foreign key of the “1” side in the table of the “many” side as a primary key.
8. When using the Crow’s Foot notation, the associative entity is indicated by _____ relationship
lines between the parents and the associative entity.
9. In a database context, a(n) _____ indicates the use of different names to describe the same
attribute.
10. Complex _____ requirements may dictate data transformations, and they may expand the
number of entities and attributes within the design.
PREVIEW
