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

____________________ involves combining two or more tables in a relational database.

In the relational data model, each column of a table represents a(n) ____________________.

In many organizations, information is stored in more than one location, which makes it difficult to maintain because there is much duplication.What is the term used to refer to this problem in data?

A consultant has been hired to help a company identify a specific requirement for a project.The consultant sets out to identify the informational elements including its usage and access.What method is this being used?

What is a database?

The ____________________ data model has become the most popular database model.

What is the name given to a system used to analyze financial and operating data?

Business and technology vendors are working to develop blue data centres that run more efficiently and require less energy for processing and cooling.

Online analytical processing and data mining are essentially the same.

A data centre that is fully automated to the extent that it can run and manage itself while being monitored remotely is said to operate in a(n) ____________________ environment.

A(n) ____________________ is a simple database program whose records have no relationship to one another and are often used to store a single table or file.

The business user asks the data analyst for a database to capture information about all the customers including personal information.In preparation, the data analysis identifies the list of attributes to be used for the database.What is the name of this list?

Differentiate between the traditional and database approaches to data management.

The commands that are used to manipulate the database are part of the ____________________ language.

Who is responsible for planning, designing, creating, operating, securing, monitoring, and maintaining databases?

What is the smallest piece of data used by a computer?

What is the primary consideration when selecting a database management system for an organization?

Who is responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization?

Identify 10 advantages of the database approach to data management.

The data ____________________ is a detailed description of all data used in the database.