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

In a(n)_____  access file structure,records can be accessed in any order,regardless of their physical locations in storage media.

In a _____ model,the relationships among records form a treelike structure.

Data in a database is used for analytical purposes,whereas data in a data warehouse is used for capturing and managing transactions.

Briefly explain the responsibilities of a database administrator (DBA).

Discuss why an organization might choose a distributed database.

With the indexed sequential access method (ISAM),records cannot be accessed randomly.

In data warehouses,_____ is information about data-its content,quality,condition,origin,and other characteristics.

Briefly discuss the advantages and disadvantages of database marketing.

In a relational database model,which operation pares down a table by eliminating columns according to certain criteria?

Data warehouses are sometimes called hypercubes because they _____.

A _____ is software for creating,storing,maintaining,and accessing database files.

In a relational database model,the rows are called _____.

The advantage of the _____ access method is that both sequential and random access can be used to access records,depending on the number being accessed.

To begin designing a relational database,you must define the _____ by defining each table and the fields in it.

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

A _____ converts logical requests from users into their physical equivalents by interacting with other components of the database management system (DBMS).

The first step in database design is defining a _____,which determines how data is created,represented,organized,and maintained.

In comparison with flat file systems,databases:

Describe the features and benefits of an object-oriented database.

The data _____ component of a database management system (DBMS)is used to add,delete,modify,and retrieve records from a database.