Ch4 Relational Database

A set of interrelated, centrally coordinated data files that are stored with as little data redundancy as possible

Program that manages and controls the data and the interfaces between the data and the application programs that use the data stored in the database

The database, the DBMS, and the application programs that access the database through the DBMS

The person responsible for coordinating, controlling, and managing the database

Very large database containing detailed and summarized data for a number of years that are used for analysis rather than transaction processing

Analyzing large amounts of data for strategic decision making

Using queries to investigate hypothesized relationships among data

Using sophisticated statistical analysis to "discover" unhypothesized relationships in the data

Document that shows the items stored in a file, including the order and length of the data fields and the type of data stored

How people conceptually organize, view, and understand the relationships among data items

The way data are physically arranged and stored in the computer system

A description of the data elements in a database, the relationships among them, and the logical model used to organize and describe the data

The organization-wide view of the entire databse that lists all data elements and the relationships between them

An individual user's view of portions of a database; also called a subschema

A subset of the schema; the way the user defines the data and the data relationships

A low-level view of the entire database describing how the data are actually stored and accessed

Information about the structure of the database, including a description of each data element

DBMS language that builds the data dictionary, creates the database, describes logical views, and specifies record or field security constraints

DBMS language that changes database content, including data element creations, updates, insertions, and deletions

High-level, English-like, DBMS language that contains powerful, easy-to-use commands that enable users to retrieve, sort, order, and display data

DBMS language that simplifies report creation

An abstract representation of database contents

A two-dimensional table representation of data; each row represents a unique entity (record) and each column is a field where record attributes are stored.

A row in a table that contains data about a specific item in a database table

Database attribute, or combination of attributes, that uniquely identifies each row in a table

An attribute in a table that is also a primary key in another table; used to link the two tables

Improper database organization where a non-primary key item is stored multiple times; updating the item in once location and not the others causes data inconsistencies

Improper database organization that results in the inability to add records to a database

Improper organization of a database that results in the loss of all information about an entity when a row is deleted

A database built using the relational data model

A non-null primary key ensures that every row in a table represents something and that it can be identified

Foreign keys which link rows in one table to rows in another table must have values that correspond to the value of a primary key in another table

Following relational database creation rules to design a relational database that is free from delete, insert, and update anomalies

Using knowledge of business processes and information needs to create a diagram that shows what to include in a fully normalized database (in 3NF)