Databases CSCI 201 Principles of Software Development

Flashcards covering key concepts from databases and SQL as discussed in the lecture.

Relational Database Management System (RDBMS)

A system that provides a structured way to store, retrieve, and manage data using tables.

Primary Key

A unique identifier for a record in a database table.

Foreign Key

A field that creates a link between two tables by referencing a primary key in another table.

Normalization

The process of organizing data to reduce redundancy and improve data integrity.

Tuples

Rows in a database table that represent individual records.

Attributes

Columns in a database table that define characteristics of the stored data.

Database Management System (DBMS)

Software that provides tools for managing data in databases.

SQL (Structured Query Language)

The primary language used to interact with and manipulate databases.

INSERT Statement

An SQL command used to add new records to a database table.

SELECT Statement

An SQL command used to retrieve data from a database table.

CREATE TABLE Statement

An SQL command used to create a new table within a database.

Data Integrity

The accuracy and consistency of data over its lifecycle.

JOIN (INNER JOIN)

An SQL operation that combines rows from two or more tables based on a related column.