The Relational Data Model

4 important questions on The Relational Data Model

What is data integrity enforced by?

  • Using null for missing data
  • Specified domains for attributes
  • Entity integrity
  • Referential integrity
  • Enterprise constraints

How do you ensure entity integrity?

  • Specify a primary key
  • No attribute of a primary key can be null
  • Tables for weak entities should inherit (part of) their primary key from their parent tables

How do you ensure referential integrity?

Foreign key values must match a key value of some row in the parent table or be null
  • Higher grades + faster learning
  • Never study anything twice
  • 100% sure, 100% understanding
Discover Study Smart

What are enterprise constraints?

Additional rules specified by users or database administrators

e.g. only 20 staff allowed at one branch. DBMS must enforce this rule

The question on the page originate from the summary of the following study material:

  • A unique study and practice tool
  • Never study anything twice again
  • Get the grades you hope for
  • 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
Trustpilot Logo