Relational Databases and Enterprise Systems

Flashcards covering essential terms and definitions related to relational databases and enterprise systems.

Relational Database

A data model that stores information in the form of related two-dimensional tables.

Database Management System (DBMS)

A computer program that creates, modifies, and queries the database.

Primary Key (PK)

A key that uniquely identifies a specific row in a table.

Foreign Key (FK)

An attribute in one table that acts as a primary key in another table, providing a link between two tables.

Entity Integrity Rule

The primary key must have data values and cannot be null.

Referential Integrity Rule

The data value for a foreign key must either be null or match one of the data values that already exist in the corresponding table.

Structured Query Language (SQL)

A computer language designed to query and update data in a relational database.

INSERT Operator

A SQL command used to create a new record in a database.

SELECT Operator

A SQL command that begins a query, specifying which columns of a table should be included in the query.

Aggregate Functions

Functions in SQL that perform calculations on multiple rows, such as AVG, SUM, MAX, MIN, and COUNT.

Data Dictionary

Describes the data fields in each database record including field description, field length, and field type.

Cloud Computing

Internet-based computing where shared resources, software, and information are provided to firms on demand.