Chapter 10 - Working with Multiple Tables

Vocabulary terms and definitions covering table relationships, redundancy control, and referential integrity from Chapter 10.

Reduced Data Redundancy

An advantage of relating tables where duplicating data across the database is avoided, such as storing customer information in one table and orders in another.

Improved Data Integrity

An advantage of relating tables that ensures data accuracy and consistency, such as ensuring every order is linked to an existing customer to prevent orphan records.

Normalization

The process of organizing tables to reduce duplicate data, such as storing customer information in a separate "Customers" table instead of repeating it in every order record.

Referential Integrity

The principle stating that no unmatched foreign key values should exist in the database; specifically requiring that a foreign key value in one table must match a primary key value in another table or be null.

DBMS

The system that manages data integrity once a relationship between two tables has been set, enforcing rules to ensure data remains consistent and accurate.

One-to-One Relationship

A relationship where one specific record of a master table has one and only one corresponding record in the transaction table (e.g., a person having only one passport).

One-to-Many Relationship

A relationship where one specific record of the master table has more than one corresponding record in the related transaction table (e.g., an author writing many books).

Many-to-Many Relationship

A relationship where multiple records in the master table correspond to multiple records in the transaction table, typically set when certain records must be saved more than once in both related tables.