Tag: databases

True

False

50

100

150

200

SETLL

SETGT

Both 1 & 2

Neither 1 nor 2

SETLL + READP

SETGT + READP

SETLL + READE

SETGT + READE

True

False

A system that is used to run the business in real time and is based on historical data.

A system that is used to run the business in real time and is based on current data.

A system that is used to support decision making and is based on current data.

system that is used to support decision making and is based on historical data.

Many-to-many

One-to-one

One-to-many

All of the above

Completely normalized

Partially normalized

Completely denormalized

Partially denormalized

Data stored in the various operational systems throughout the organization.

Current data intended to be the single source for all decision support systems.

Data stored in one operational system in the organization.

Data that has been selected and formatted for end-user support applications.

Can be updated by end users

Contains numerous naming conventions and formats

Organized around important subject areas.

Contains only current data.