Exam 5: Database Systems, Data Centres, and Business Intelligence

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

In what type of database can data be spread across several smaller databases connected through telecommunications devices?

Briefly describe the relational data model.

The allowable values for an attribute are called its ____________________.

A data warehouse stores historical data that has been extracted from operational systems and external sources.

A report from IDC estimates that the amount of information humanity creates will grow by a factor of ____________________ between 2009 and 2020.

The business systems analyst has identified a data modelling approach to help in the understanding of the business requirements.What is an example of a tool to help in the data modelling?

A record is a collection of fields about a specific object.

Define the term "data mining" and identify its objectives.

One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and data to be organized more logically.

Briefly describe the hierarchy of data.

Which of the following is a visual approach to developing database requests?

The tables in a relational database can be linked to provide useful information and reports so long as they share which of the following?

What is a collection of fields about a specific object called?

Identifying who will have access to a database has little impact on organizing a database.

____________________ is a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events.

Projecting involves eliminating columns in a table.