Database & SQL Multiple Choice Questions

Flashcards covering key terminology and concepts related to database management and SQL from the provided lecture notes.

SQL

Structured Query Language.

DBMS

Database Management System, responsible for defining data, executing queries, and displaying query results.

Client/Server architecture

An architecture where the application resides on local computers.

TPS system

Transaction Processing System, captures information about detailed business operations.

DSS system

Decision Support System, utilizes multiple databases including internal and external data.

Online Transaction Processing database

A database used for daily business processing.

Data mining

The process of analyzing data sets to identify patterns and trends.

Database schema

Defines the structure of the database, including keys and indices.

DELETE

The SQL statement used to remove rows from a table.

JOIN

The process of linking records in different tables.

DISTINCT

The SQL keyword used to eliminate duplicate values.

Parentheses

Used in SQL to override normal precedence of AND, OR, and NOT.

CARDINALITY

Describes the number of instances in one entity related to a single instance in another entity.

ENTITY

A tangible thing or concept represented within the database.

COMPOSITE key

A key that consists of more than one column.

ENTITY integrity

A rule that states no key column value may be null.

FOREIGN key

A column in one table that links to a primary key in another table.

TUPLE

A row in a relational database.

FIRST Normal Form

A rule that requires all attribute values in a table to be atomic.

BOOLEAN logic

A form of algebra that handles true and false values, often used in query conditions.