Lecture #3 «Introduction into RDBMS»

Hi there!

You can find out here of “Introduction into Relational Databases” course with theme “Relational Model”.


RDBMS Lecture 3

Themes are below.

  • Relational Model
  • Edgar Frank Codd
  • 12 Codds’ rules (~ 12 rules of RDBMS)
  • Fundamental Properties of Relational Model
  • Chris Date and Hugh Darwen
  • Domains
  • Cartesian Product
  • What does NULL mean?
  • Tables DEE and DUM
  • IS_EMPTY
  • Relational Variable
  • Closed World Assumption
  • Relational Model Integrities
  • Keys (Primary, Foreign, Unique, Alternatives, Candidates)
  • Foreign Keys Options
  • Defferred constraints
  • No Validate Option
  • Database Views / Materialized Views
  • ANSI-SPARK Architecture

Please if you have some comments / questions or remarks , just let me know about it.

Thanks!