Database components

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
4
Level: 
I
  • Definition of the components of a relational database
    • Table
    • Attribute
    • Tuple
  • Relational schemas
    • Introduction relational schemas
    • Main keys to identify only one record
    • Main keys having plural attributes
    • External keys.
  • Set operations
    • Union
    • Difference
    • Intersection
    • Cartesian product
  • Relational algebraic operations
    • Projection
    • Join
    • Selection (Restriction)
    • Division
  • Ways to maintain consistency among components of a relational database, as well as conditions necessary to maintain consistency.