Database

Front 1

Phases of Relational Database Design

Back 1

1) Analysis
2)Design
3)Implementation

Front 2

Client Requirements

Back 2

Information collected from client to create sound database design

Front 3

Business Rules

Back 3

Procedures and policies of company that would affect input of data into database

Front 4

TABLE

Back 4

Set of data elements that are organized using a model of columns and rows.

Front 5

DATA FIELD

Back 5

Column in a database

Front 6

DATA FIELD

Back 6

Also called an "attribute"

Front 7

KEY

Back 7

Data field that ensures each record is uniquely identified

Front 8

Candidate Key

Back 8

A field or combination of fields that uniquely identify each record in a table.

Front 9

Primary Key

Back 9

A field that would always accept unique value and never a blank.

Front 10

Foreign Key

Back 10

A field that matches the primary key column of another table

Front 11

Null Value

Back 11

Value used to indicate the absence of data in a given field

Front 12

RELATIONSHIP

Back 12

Method used to link two tables based on presence of a common field that is found in both tables

Front 13

CARDINALITY

Back 13

Relationship among tables based on the number of rows in one table related to the number of rows in another table.

Front 14

Bridge Table

Back 14

Tables used to avoid many-to-many relationships in database.

Front 15

Entity Relationship Diagram

Back 15

Graphical representation of the design of the database.

Front 16

Data Anomaly

Back 16

Data inconsistency in table when rows are inserted, updated, or deleted.