Exam 3: Data and Business Intelligence

Discuss how data was stored in flat files in the past. Explain the disadvantages associated with the flat file organization.

In contrast to the query languages used to interact with a relational database, interaction with an object-oriented database takes places via methods, which are called by sending a message to an object.

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

When using query by example (QBE)in the data manipulation component of a database management system (DBMS), the _____ is used when all the conditions in the QBE form must be met.

In the context of the types of data in a database, which is a source of internal data?

In the context of business analytics, which method reviews past events, analyzes the data, and reports on what happened in a given period?

Explain the function of the data definition component of a database management system.