Chapter 4 Dynamic

Which two key techniques are used in business intelligence?

Online analytical processing (OLAP) and data mining.

What is the entity integrity rule?

Ensuring that every row in a table represents something uniquely and can be identified.

What is a data warehouse?

One or more large databases for analytical processing.

What is a key feature of database systems in overcoming the challenge of separating the storage of data from the use of data elements?

Providing two separate views of the data: the physical view and the logical view.

What is a relational data model?

A relational data model organizes data into tables with rows representing occurrences and columns representing attributes.

What is the primary function of a Database Management System (DBMS)?

To facilitate efficient communication between data and application programs.

What is an Online Transaction Processing Database (OLTP)?

A database specialized in processing normal business transactions.

What is one approach to designing a relational database, which starts by assuming that everything is initially stored in one large table?

Normalization

What does online analytical processing (OLAP) involve?

Using queries to examine relationships among data.

What does a database system consist of?

The database, the database management system (DBMS), and the application programs.

What is the purpose of referential integrity?

Ensuring database consistency by maintaining relationships between tables.

It is a constraint that ensures database consistency.

How is the data in every database typically presented?

Both a logical and a physical view.