Exam 3: Database Systems,data Warehouses,and Data Marts

The ____________________ view of a database involves how information appears to users and how it can be organized and retrieved.

Business analytics uses ____ to support decision-making activities.

The database component of an information system accesses only internal data.

The data ____ component is used for tasks such as backup and recovery,security,and change management.

Describe the fragmentation approach to setting up a DDBMS?

In contrast to the query languages used to interact with a relational database,interaction with an object-oriented database takes places via methods.

A(n)____________________ is software for creating,storing,maintaining,and accessing database files.

A distributed database is not limited by the data's physical location.

____ generally uses internal data and responds in real time.

A ____ key uniquely identifies every record in a relational database.

____________________ refers to new objects being created faster and more easily by entering new data in attributes.

For each database,there can be more than one physical view of data.

In a(n)____________________ access file structure,records in files are organized and processed in numerical order.

As compared to data warehouses,consolidating information from different departments or functional areas is easier in data marts.

Flat file organization tends to take up unnecessary storage space.

Data redundancy is eliminated or minimized in a flat file system.

Briefly describe "flat files."

____________________ processing is done to make sure data meets the data warehouse's needs.

The ____ view involves how data is stored on and retrieved from storage media.

What is a relational model?