CIS 4600 Chapter 2 Terms.txt

  1. An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances
    Associative Entity 78
  2. A property or characteristic of an entity or relationship type that is of interest to the organization
    Attribute 70
  3. A relationship between the instances of two entity types
    Binary Relationship 81
  4. A statement that defines or constrains some aspect of the business. It is intended to assert business structure or to control or influence the behavior of the business.
    Business rule 61
  5. A rule that specifies the number off instances of one entity that can (or must) be associated with each instance of another entity.
    Cardinality constraint 85
  6. An attribute that has meaningful component parts (attributes).
    Composite attribute 71
  7. An identifier that consists of a composite attribute.
    Composite identifier 72
  8. The number off entity types that participate in a relationship.
    Degree 79
  9. Ann attribute whose values can be calculated from related attribute values.
    Derived attribute 72
  10. A person, a place, an object, an event, or a concept in the user environment about which the organization wishes to maintain data.
    Entity 66
  11. A single occurrence of an entity type.
    Entity instance 66
  12. A graphical representation of an entity-relationship model.
    Entity-Relationship Diagram 57
  13. A logical representation of the data for an organization or for a business area, using entities for categories of data and relationships for associations between entities.
    Entity-relationship model 57
  14. A collection of entities that share common properties or characteristics.
    Entity type 66
  15. An association between two or more terms.
    Fact 64
  16. An attribute or combination of attributes, whose value distinguishes instances off an entity type.
    Identifier 72
  17. The entity type on which the weak entity type depends.
    Identifying owner 68
  18. The relationship between a weak entity type and its owner.
    Identifying relationship 68
  19. The maximum number of instances of one entity that may be associated with each instance of another entity.
    Maximum cardinality 85
  20. The minimum number of instances of one entity that may be associated with each instance of another entity.
    Minimum Cardinality 85
  21. An attribute that may take on more than one value for a given entity (or relationship) instance.
    Multivalued attribute 71
  22. An attribute that may not have a value for every entity (or relationship) instance with which it is associated.
    Optional attribute 70
  23. An association between or among entity instances where each relationship instance associated exactly one entity instance from each participating entity type.
    Relationship instance 76
  24. A meaningful association between or among entity types.
    Relationship type 76
  25. An attribute that must have a value for every entity or relationship instance with which it is associated.
    Required attribute 70
  26. An attribute that cannot be broken down into smaller components that are meaningful to the organization.
    Simple or atomic attribute 71
  27. An entity that exists independently of other entity types.
    Strong entity type 67
  28. A word or phrase that has specific meaning to the business.
    Term 64
  29. A simultaneous relationship among the instances of three entity types.
    Ternary relationship 82
  30. A time value that is associated with a data value, often indicating when some event occurred that affected the data value.
    Time stamp 88
  31. A relationship between instances of a single entity type.
    Unary Relationship 79
  32. An entity type whose existence depends on some other entity type.
    Weak entity type 67
Card Set
CIS 4600 Chapter 2 Terms.txt
Modern Database Management 11th Edition Chapter 2 Terms Vocabulary