Exam 5: Database Systems and Applications

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.

Some databases use ______, which is a visual approach to developing queries and requests.

_____ is a form of data mining that combines historical data with assumptions about future conditions to forecast the outcomes of events.

A(n) _____ is a detailed description of all data used in a database.

_____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.

Briefly describe the relational database model.

A(n) _____ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

In the context of relational database model, selecting involves combining two or more tables.

Describe business intelligence (BI).

Basic data manipulations include _____ that involves eliminating rows in a relational database according to certain criteria.

Online analytical processing and data mining are essentially the same thing.

In the context of a database management system (DBMS), a(n) _____ interacts with other programs or applications and only indirectly interacts with people or users.

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

_____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of dealing with them.

Two sets of fields can have a common primary key.

Together, bits, characters, fields, records, files, and databases form the ______.

Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, MySQL, and Sybas are databases based on the _____ model.

Competitive intelligence is espionage.

In the relational database model, each row of a table represents a(n) _____.

The _____ is a specific language, provided with a database management system (DBMS) that allows users to access and modify the data, to make queries, and to generate reports.