ACC306 Flashcards

These flashcards cover key concepts related to database management systems, including definitions of data manipulation languages, relational table structures, and anomalies associated with data handling.

DDL (Data Definition Language)

Used to define the database structure, including creating and altering tables.

DML (Data Manipulation Language)

Used to manipulate and manage data within the database, including updates and transactions.

DQL (Data Query Language)

Used to query and retrieve information from the database, often through SELECT statements.

Update Anomaly

Occurs when changes to data are not correctly reflected across all database instances.

Insert Anomaly

Occurs when certain attributes cannot be inserted into the database without the presence of other attributes.

Delete Anomaly

Occurs when deletion of data results in the loss of additional important information.

Relational Table

A table in a relational database that organizes data into rows and columns.

Primary Key (PK)

A unique identifier for a record in a table.

Foreign Key (FK)

A field in a table that is a primary key in another table, used to establish a relationship between the two tables.

Good Database Design

Refers to the principles and practices that ensure data integrity, consistency, and ease of use in a database.