Exam 6: Databases and Information Management

A(n)________ view shows data as it is actually organized and structured on the data storage media.

Detecting and correcting data in a database or file that are incorrect,incomplete,improperly formatted,or redundant is called

A group of bits,called a ________,represents a single character,which can be a letter,a number,or another symbol.

The ________extracts current and historical data from multiple operational systems inside the organization.

Data cleansing is the same process as data scrubbing.

In a relational database,a record is referred to in technical terms as a(n)

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

A line connecting two entities that ends in two short marks designates a ________ relationship.

Darren Pepper works for a large medical clinic.They are running out of five-digit patient numbers and they want to expand the patient number to seven digits.It will cost a great deal of money to make this switch because three of the clinic's programs will no longer work with this new number of digits in the patient number.The clinic is using a traditional file system.This is an example of ________.

Program-data dependence refers to the coupling of data stored in files and software programs that use this data such that changes in programs require changes to the data.

OODBMS are slower than relational DBMS.

An object-oriented DBMS stores the data and procedures that act on those data as objects that can be automatically retrieved and shared.

A DBMS separates the logical and physical views of the data.

The select operation creates a subset consisting of columns in a table,permitting the user to create new tables that contain only the information required.

The ________ operation creates a subset consisting of columns in a table,permitting the user to create new tables that contain only the information required.

The small publishing company you work for wants to create a new database for storing information about all of their author contracts.What factors will influence how you design the database?

A group of bytes,called a bit,represents a single character,which can be a letter,a number,or another symbol.

________ mining is the discovery of patterns and relationships from large sets of unstructured data-the kind of data we generate in e-mails,phone conversations,blog postings,online customer surveys,and tweets.

Describe the ways in which database technologies could be used by an office stationery supply company to achieve product differentiation.

What makes data mining an important business tool? What types of information does data mining produce? In what type of circumstance would you advise a company to use data mining?