Midterm Exam Study

Fall 2011

Concepts:

  • Logical Data Model
  • Entity Relationship Diagram
  • Strong and Weak entity
  • Relationship Cardinality
  • Attribute domains
  • Attribute kind: optional, composite, required, derived
  • Functional Dependency, full dependency, partial dependency, transitive dependency
  • Determinate
  • Candidate Key, Primary Key, Foreign Key
  • Binary, Unary, Ternary Relationship
  • Subtype, Supertype relationships
  • Attribute inheritance
  • Business Rules
    • Convert ER into business rules
    • Convert business rules into ER
  • Relation properties
    • Uniqueness
    • Referential Integrity
  • Consistency Anomalies
    • Update Anomalies
    • Deletion Anomalies
    • Addition Anomalies
  • First, Second, Third Normal Forms
  • Relational Algebra
    • Selection
    • Projection * Join
    • Outer
    • Natural
    • Equijoin
    • Left Outer
    • Right Outer
    • Theta
    • Difference
    • Union
    • Intersection
    • Division
    • Product
-- JimSkon - 2011-10-08
Topic revision: r1 - 2011-10-08 - JimSkon
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback