Describe the main characteristics of the Relational Data Model, including the properties of relations and the rules for relational integrity.

Question

Quizplus · Accepted Answer

The Answer is Relational
- set of tables (as perceived by users)
- rows/columns
- variety of possible storage structures
- no repeating groups
- no links/pointers
- use of join columns.
- no duplicate tuples
- tuples are unordered
- attributes are unordered
- all attribute values are atomic.
Entity Integrity: No attribute participating in the PK of a base relation is allowed to accept null values.
Referential Integrity: If a base relation R2 includes a FK targeting the PK of R1, then every value of FK must either be:
- equal to the value of PK in some tuple of R1 or
- wholly null.

Describe the Main Characteristics of the Relational Data Model, Including