Database 1 Final Exam Review

The process of decomposing a tables into smaller tables, to minimize data redundancy and improve data integrity

A relationship between two attributes, where the value of one attribute determines the value of another attribute

A table is in this form if it has no repeating groups, and each attribute contains only atomic values

A table is in this form if it is in 1NF, and all non-key attributes are dependent of the entire primary key

A table is in this form if it is in 2NF, and all non-key sttributes are dependent only on the primary key

A table is in BCNF if for every functional dependency, the determinant is a candidate key.

A graphical representation of entities and their relationships to each other.

An object or concept that is represented in the database and has attributes

The association between two or more entities.

The number of instances of one entity that can be related to the number of instances of another entity.

The process of applying normalization rules to ensure that a database is structured correctly and efficiently.

A repository of information about the data in a database.

A query that is nested inside another query.

A subquery that is dependent on the outer query and is executed for each row returned by the outer query.

A function that performs a calculation on a set of values and returns a single value.

A clause in a SQL statement that groups the results of a query by one or more columns.

A clause in a SQL statement that filters the results of a query based on a specified condition.

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

A collection of data that is organized in a specific way and can be accessed by various applications.

a programming language used for managing relational databases.

set of related data organized in rows and columns.

A unique identifier for a row in a table.

A field in one table that refers to the primary key of another table.

A data structure that allows for faster searches and retrieval of data in a table.

A request for data from one or more tables, using SQL statements.

A virtual table that displays data from one or more tables.

A set of SQL statements that automatically execute in response to a specific event in a database.

A pre-written set of SQL statements that can be executed repeatedly.

A set of SQL commands used to manipulate data in a database.

A set of properties that guarantee reliable processing of database transactions: Atomicity, Consistency, Isolation, and Durability.