Part 2 of CS347

Exclusive Subtypes

An entity must belong to only one subtype, represented with disjoint constraints.

Inclusive Subtypes

An entity can belong to multiple subtypes, represented with overlapping constraints.

Discriminator Attribute

Used to determine which subtype an entity belongs to, e.g., 'Person_Type' in a 'Person' table.

Intersection Table

Used to resolve many-to-many relationships by creating two 1:M relationships.

Many-to-Many Relationship

A relationship where multiple entities in one table can relate to multiple entities in another table.

Denormalization

The process of combining normalized tables into a single table for performance optimization.

SQL Trigger

An automated database action executed when a specified event occurs.

View

A virtual table derived from a query that simplifies complex queries and enhances security.

Subquery

A nested query used to retrieve information from one or more tables based on values from another query.

Cardinality

Defines the maximum and minimum number of entities that participate in a relationship.

DDL (Data Definition Language)

Used to define and modify database structures like tables.

DML (Data Manipulation Language)

Used to manipulate data in tables, including INSERT, UPDATE, DELETE operations.

Normalization

The process that eliminates redundant data and reduces update anomalies.

JOIN

Combines rows from two or more tables based on related columns, often used for query optimization.

Bridge Table

Another term for junction tables that facilitate many-to-many relationships in databases.