1. Data Structure
    data are organized in the form of tables with rows an dcolumns
  2. Data Manipulation
    powerful operations (using the SQL language) are used to manipulate data stored in the relations
  3. Data Integrity
    facilities are included to specify business rules that maitain the integrity of data when they are manipulated
  4. Relation
    a named two-dimensional table of data
  5. Primary Key
    an attribute (or combination of attributes) that uniquely identifies each row in a relation
  6. Composite Key
    a primary key that consists of more than one attribute
  7. Foreign Key
    an attribute in a relation that serves as the primary key of another relation in the same database
  8. Domain
    • the set of values that may be assigned to an attribute.
    • all of the values that appear in a column of a relation must be taken from the same domain.
  9. Null
    a value that may be assigned to an attribute when no other value applies or when the applicable value is unknown
  10. Entity Integrity Rule
    no primary key attribute (or component of a composite primary key) may be null
  11. Referential Integrity Constraint
    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
  12. Well-Structured Relation
    a relation that contains minimal redudndancy an dallows users to insert, modify, and delete the rows in a table withoout errors or inconsistencies
  13. Anomaly
    an error or inconsistency that may result when a user attempts to update a table that contains redudnant data. the three types of anomalies are insertion, deletion, and modification
  14. Regular Entities
    entities that have an independent existence and generally represent real-world objects, such as persons and products. Regular entity types are represented by rectangles with a single line
  15. Weak Entities
    entities that cannot exist except with an identifying relationship with an owner (regular) entity type. Weak entities are identified by a rectangle with a double line
  16. Associative Entities
    (gerunds) are formed from many-to-many relationships between other entity types. associative entities are represented by a rectangle with rounded corners
  17. 7 Steps:
    • 1. Map regular entities
    • 2. Map weak entities
    • 3. Map binary relationships
    • 4. Map associative entities
    • 5. Map unary relationships
    • 6. Map ternary (and n-ary) relationships
    • 7. Map supertype/subtype relationships
  18. Surrogate Primary Key
    a serial number or other system assigned primary key for a relation
  19. Recursive Foreign Key
    a foreign key in a relation that refernces the primary key values of that same relation
Card Set
Modern Database Management Ch. 5 Hoffer, Prescott, Topi