CIS 4600 Chapter 4 Terms

Card Set Information

CIS 4600 Chapter 4 Terms
2012-09-27 16:46:13
Business Modern Database Management 11th Edition Hoffer Ramesh Topi CIS4600

Modern Database Management 11th Edition Chapter 4 Terms Vocabulary
Show Answers:

  1. An alternative name used for an attribute.
    Alias pg187
  2. An attribute in a relation that serves as the primary key of another relation in the same database
    Foreign key pg156
  3. An attribute or a combination of attributes that uniquely identifies each row in a relation.
    Primary key pg155
  4. Two or more attributes that have different names but the same meaning.
    Synonyms pg186
  5. An error or inconsistency that may result when a user attempts to update a table that contains redundant data.  The three types of anomalies are insertion, deletion and modification anomalies.
    Anomaly pg162
  6. A constraint between two attributes in which the value of one attribute is determined by the value of another attribute.
    Functional dependency pg178
  7. A foreignkey in a relation that references the primary key values of the same relation.
    Recursive foreign key pg171
  8. A relation that is in second normal form and has no transitive dependencies.
    Third normal form (3nf) pg183
  9. An attribute, or combination of attributes, that uniquely identifies a row in a relation.
    Candidate key pg178
  10. An attribute that may have more than one meaning.
    Account can refer to a bank account, a student account or any other type of account.  Therefore, account refers to different data depending on how it is used.  (This is bad DB design)
    Homonym pg187
  11. A rule that states that either each foreign key value must match a primary key value in another relation or the foreign key value must be null.
    Referential integrity constraint pg160
  12. A functional dependency between the primary key and one or more nonkey attributes that are dependent on the primary key via another nonkey attribute.
    Transitive dependency pg183
  13. The attribute on the left side of the arrow in a functional dependency.
    Determinant pg178
  14. A state of relation that requires that certain rules regarding relationships between attributes (or functional dependencies) are satisfied.
    Normal form pg177
  15. A named two-dimensional table of data.
    Relation pg 155
  16. A relation that contains minimal redundancy and allows users to insert, modify, and delete the rows in a table without errors or inconsistencies.
    Well-Structured relation pg162
  17. A primary key whose value is unique across all relations.
    Enterprise key pg188
  18. The process of decomposing relations with anomalies to produce smaller, well-structured relations.
    Normalization pg176
  19. A relation in first normal form in which every nonkey attribute is fully functionally dependent on the primary key.
    Second normal form (2nf) pg182
  20. A rule that states that no primary key attribute (or component of a primary key attribute) may be null.
    Entity integrity rule pg159
  21. A value that may be assigned to an attribute when no other value applies or when the applicable value is unknown.
    Null pg159
  22. A serial number or other system-assigned primary key for a relation.
    Surrogate primary key pg166
  23. A relation that has a primary key and in which there are no repeating groups.
    First Normal Form (1NF) pg181
  24. A functional dependency in which one or more nonkey attributes are functionally dependent on part (but not all) of the primary key.
    Partial functional dependency pg182