partial dependency A.) is the result of simultaneous user requests for the same data in a partitioned 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.) may exist in tables that are

partial dependency A.) is the result of simultaneous user requests for the same data in a partitioned 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.) may exist in tables that are

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 partial dependency a. is the result of simultaneous user requests for the same data in a partitioned 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. may 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.
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.
Which statement is NOT correct? The indexed sequential access methoda. is used for very large files that need both direct access and batch processing.b. may use an overflow area for records.c. provides an exact physical address for each record.d. is appropriate for files that require few inser- tions or deletions.
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.
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.
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 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.
Which statement is NOT true?a. In a typical two-tier client-server architecture, the server handles both application and database duties.b. Client computers are responsible for presenting data to the user and passing user input back to the server.c. Two-tier architecture is for local area network applications where the demand on the server is restricted to a relatively small population of users.d. The database and application functions are separated in the three-tier model. e. In three-tier client-server architectures, one tier is for user presentation, one is for database and applications access, and the third is for Internet access.
Partitioned databases are most effective when a. users in the system need to share common data. b. primary users of the data are clearly identifiable.c. read-only access is needed at each site. d. all of the above.