Fundamentals of Database Systems: Basic SQL

Flashcards covering key vocabulary and concepts from Chapter 6 of the Fundamentals of Database Systems, focusing on Basic SQL.

SQL

Structured Query Language, used for managing relational databases.

CREATE statement

Main SQL command for data definition.

Data Manipulation

Refers to operations that allow users to retrieve, insert, update, and delete data in a database.

Primary Key

A unique identifier for a record in a table that cannot be duplicated or null.

Foreign Key

A field in one table that uniquely identifies a row of another table, establishing a relationship between the two tables.

Integrity Constraints

Rules that ensure the accuracy and consistency of data within the database.

SELECT statement

SQL command used to retrieve data from one or more tables.

WHERE clause

A condition that must be met for records to be included in the result set of a query.

ORDER BY clause

Specifies the order of the results returned by a SELECT statement.

INSERT command

SQL command used to add new records to a table.

UPDATE command

SQL command used to modify existing records in a table.

DELETE command

SQL command used to remove records from a table.

Schema

A logical structure that defines the organization of data in a database.

Tuple

A single row in a table, representing a single record.

View

A virtual table based on the result set of a SELECT query that does not store data physically.

Data Type

Specifies the kind of data that can be stored in a database column such as INTEGER, VARCHAR, etc.

DISTINCT keyword

Used in SQL to return only distinct (different) values.

LIKE operator

Used to search for a specified pattern in a column.

BETWEEN operator

Used to filter the result set within a certain range.

Arithmetic Operators

Operators used in SQL for performing mathematical calculations, such as addition (+), subtraction (-), multiplication (*), and division (/).

Transaction Control

Commands that ensure database transactions are processed reliably.