Repeating group dataa. is a form of data redundancy common to replicated databases in a distributed database environment.b. is a name given to one of the three anomalies that result from unnormalized database tables.c. can exist only in a table with a composite primary key.d. cannot exist in tables that are normalized at the 2NF level.e. is none of the above.

Repeating group dataa. is a form of data redundancy common to replicated databases in a distributed database environment.b. is a name given to one of the three anomalies that result from unnormalized database tables.c. can exist only in a table with a composite primary key.d. cannot exist in tables that are normalized at the 2NF level.e. is none of the above.

Accounting Information Systems

10th Edition

ISBN:9781337619202

Author:Hall, James A.

Publisher:Hall, James A.

Chapter9: Database Management Systems

Section: Chapter Questions

Problem 14MCQ

See similar textbooks

Similar questions

A transitive dependencya. is a database condition that is resolved through special monitoring software.b. is a name given to one of the three anomalies that result from unnormalized database tables.c. can exist only in a table with a composite primary key.d. cannot exist in tables that are normalized at the 2NF level.e. is none of the above.
Which of the following statements is not correct? a.The database approach uses one common database to promote the concept of single user view. b.Database systems resolve task data dependency. c.The flat-file model encourages data redundancy. d.A primary goal of databasesystems is to minimize data redundancy. e.Database systems provide increased accessibility to data and data integration.
The database approach has several unique characteristics not found in traditional (flat-file) systems. Which of the following statements does not apply to the database model? a. Database systems have data independence; that is, the data and the programs are maintained separately except during processing. b. Database systems contain a data-definition language that helps describe each schema and subschema. c. The database administrator is the part of the software package that instructs the operating aspects of the program when data are retrieved. d. A primary goal of database systems is to minimize data redundancy. e. Database systems provide increased accessibility to data and flexibility in its usage.
The installation of a database management system is likely to have the least impact ona. data redundancy.b. entity-wide sharing of common data.c. exclusive ownership of data.d. the logic needed to solve a problem in an application program.e. the internal controls over data access.
Which statement is NOT true? Batch processinga. is subject to deadlocks when processing commonaccounts.b. permits data to be edited in a separate computerrun.c. can use databases and flat files.d. can be initiated from a terminal.
Describe the three types of anomalies associated with database tables that have not been normalized. Using and Inventory table as an example, explain the operational implications of each anomaly.
Which of the following is NOT a database management task?a. retrievalb. storagec. summarizationd. deletion
Which statement is NOT true? a. Drill-down capability is an OLAP feature of data mining tools available to the user. b. The data warehouse should be separate from operational systems. c. Denormalization of data involves dividing the data into very small tables that support detailed analysis. d. Some decisions supported by a data warehouse are not fundamentally different from those that are supported by traditional databases. e. Data cleansing involves transforming data into standard business terms with standard data values.
Outline the traditional problems associated with the flatfile model that are resolved by the database model.
. In the relational database environment, certain accounting records (for example, journals and subsidiary ledgers) may not exist. How is this possible?
Which of the following is a characteristic of a relational database system?a. All data within the system are shared by all users to facilitate integration.b. Database processing follows explicit links that are contained within the records.c. User views limit access to the database.d. Transaction processing and data warehousing systems share a common database.
Which statement is NOT correct?a. Indexed random files are dispersed throughout the storage device without regard for physical proximity with related records.b. Indexed random files use disk storage space efficiently.c. Indexed random files are efficient when processing a large portion of a file at one time.d. Indexed random files are easy to maintain in terms of adding records.