[SA] Information Management - Logical Database Design and The Relational Model

Question Type: Short Answer

It represents data in the form of tables.

Relational Data Model

Question Type: Short Answer

Are composed of tables, rows, and columns.

Data Structure

Question Type: Short Answer

Are powerful SQL operations for retrieving and modifying data.

Data Manipulation

Question Type: Short Answer

Are mechanisms for implementing business rules that maintain integrity of manipulated data.

Data Integrity

Question Type: Short Answer

Is a named, two-dimensional table of data.

Relation

Question Type: Short Answer

it consists of rows and columns.

Table

Question Type: Short Answer

A row in a table refers to what?

Records

Question Type: Short Answer

A column in a table refers to what?

Attribute or Field

Question Type: Short Answer

Is an attribute or a combination of attributes that uniquely identifies each row in a relation.

Primary Key

Question Type: Short Answer

Is an attribute in a relation that serves as the primary key of another relation.

Foreign Key

Question Type: Short Answer

These correspond with entity types and with many-to-many relationship types.

Relations

Question Type: Short Answer

These are allowable values for an attribute.

Domain Constraints

Question Type: Short Answer

Is a value that may be assigned to an attribute when no other value applies or when the applicable value is unknown.

null

Question Type: Short Answer

A rule stating that any foreign key value must match a primary key value in the relation of the one side.

Referential Integrity

Question Type: Short Answer

An anomaly wherein adding new rows forces user to create duplicate data.

Insertion Anomaly

Question Type: Short Answer

An anomaly wherein deleting rows may cause a loss of data that would be needed for other future rows.

Deletion Anomaly

Question Type: Short Answer

An anomaly wherein changing data in a row forces changes to other rows because of duplication.

Modification Anomaly

Question Type: Short Answer

Is the attribute on the left side of the arrow in a functional dependency.

Determinant