CHAPTER 3

THE RELATIONAL MODEL

After reading this chapter, the reader will understand:

  • The relational model and its three components, namely, structural component, manipulative component and integrity constraints.
  • The relation schema and relation instance
  • Attribute and its domain
  • Unstructured and structured domain
  • Degree and cardinality of a relation
  • Characteristics of relations
  • The relational database schema and relational database instance
  • Keys including superkey, candidate key, primary key, alternate key and foreign key
  • Various types of data integrity including domain integrity, entity integrity, referential integrity and semantic integrity
  • Different types of integrity constraints
  • Legal and illegal relation
  • Constraint violation while insert, ...

Get Introduction to Database Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial