Quiz
Chapter 7
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (45)
1A major advantage of relational databases is:
- AAll records are stored together
- BNo pointers are used
- CThe ability to add tables and relationships after the database becomes operational
- DIt closely resembles a flat file
2In recent years many businesses have formed a common information source within their business organization called a database. One of the advantages of building databases is the simultaneous updating of files with common data elements. Another major advantage of the database concept is that:
- ADatabase systems can be used in microcomputers as well as on large computers
- BDatabase systems are simple to install and maintain
- CDatabase systems are generally less expensive than separate file systems
- DMore duplication of data occurs with a database system
- EFewer skilled people are required to run a database system than another system
3Within a database context, the relationship between “natural parent” and “child” would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
4Within a database context, the relationship between “military officer” and “private” would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
5Within a database context, the relationship between “students” and “classes” would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
6Within a database context, the relationship between “assigned parking space” and "car" would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
7Within a database context, the relationship between “doctor” and “patient” would most likely be:
- AOne-to-one
- BOne-to-many
- CMany-to-one
- DMany-to-many
8This item helps developers document a database:
- AData documentation detailer (DDD)
- BData dictionary
- CDatabase schema system
- DData OLAP system
9An example of a transitive dependency in a database is:
- AStudent-> grade
- BTelephone area code -> phone number
- CAirline -> flight number
- DParking Code -> parking fine amount
10An example of a transitive dependency in a database is:
- AStudent -> university course number
- BParking ticket code -> total of student parking fines
- CProduct number -> product price
- DAge -> social security number
11In the REA framework, a database designer should create a ____ for each entity.
- ARecord
- BTable
- CSecondary key
- Dall of these
12In the E-R model, this symbol represents a database entity such as a customer:
- ADiamond
- BRectangle
- CArrow
- DParallelogram
13This type of database structure enables users to create relationships after the database has been created and implemented:
- AHierarchical
- BNetwork
- CStar
- DRelational
14The REA accounting framework is most closely associated with which of the following?
- ASQL
- BAn enterprise-wide view of accounting processes
- CNormalization of accounting data for recording and query purposes
- DAn example of a data manipulation language
15Which of these would be an example of an “agent” in the REA framework?
- ASalesperson
- BCustomer
- CManager
- Dall of these are possibilities
16Which of these would be an example of a “resource” in the REA framework?
- AEquipment
- BInventory
- CCash
- Dall of these are possible examples of resources
17In the REA framework, which of these would be recorded as an “event?”
- AHiring a new president of the company
- BTaking an initial sales order from a customer
- CBuying a piece of equipment for cash
- Dall of these would be recorded as events
18In the REA framework, an account receivable would be classified as a(n):
- AAsset
- BEvent
- CResource
- Dnone of these
19All of the following are items within the data hierarchy except:
- ADatabase
- BData field
- CRecord
- Dall of these items are part of the data hierarchy
20The letter “M” in the acronym DBMS stands for “management.”
- ATrue
- BFalse
21An accounting information system database is a collection of facts and figures that serves the accounting information needs of one or more organizational subsystems.
- ATrue
- BFalse
22The correct order of elements, from smallest to largest, in the data hierarchy is data field, record, file (table), database.
- ATrue
- BFalse
23The smallest unit of information in the data hierarchy is a data field.
- ATrue
- BFalse
24The data field that distinguishes one computer record from another on a computer file is called the primary record key.
- ATrue
- BFalse
25A Social Security number is a good example of a useful primary record key.
- ATrue
- BFalse
26A foreign key is a data field in the records of one file that references a primary key in the records of another file.
- ATrue
- BFalse
27Three database concerns when creating large databases are “data integrity,” “processing accuracy,” and “data security.”
- ATrue
- BFalse
28A data dictionary is a computer file describing the data items of an accounting database.
- ATrue
- BFalse
29The term “transaction control” refers to the requirement that a database system either process a transaction entirely, or not at all.
- ATrue
- BFalse
30The idea behind concurrency control is to deny several users access to the same database record at the same time.
- ATrue
- BFalse
31The idea behind view controls is to allow users access to only that information that they need to see.
- ATrue
- BFalse
32“Protecting privacy” is an important goal in data modeling.
- ATrue
- BFalse
33“Reducing data redundancy” is an important goal in data modeling.
- ATrue
- BFalse
34The E-R model refers to the “entity-relationship” model.
- ATrue
- BFalse
35An example of a database cardinality is “one-to-many.”
- ATrue
- BFalse
36An example of a database cardinality is “one-to-one.”
- ATrue
- BFalse
37An example of a “one-to-one” relationship is “employee to assigned parking stall.”
- ATrue
- BFalse
38An advantage of relational databases is that additional indexes can be added at later points of time as new data processing requirements dictate.
- ATrue
- BFalse
39Databases cannot store more than one value in the same data field of the same record.
- ATrue
- BFalse
40A database is in first normal form if all of its record’s data fields are well defined and the information can thus be stored as a flat file.
- ATrue
- BFalse
41A database is in third normal form if all of its records are in second normal form, and there are no transitive dependencies.
- ATrue
- BFalse
42An example of a transitive relationship in a parking-tickets application is the one between “ticket code” and “fine amount.”
- ATrue
- BFalse
43An example of a transitive relationship in a medical application is the one between “medical procedure code” and “cost of treatment.”
- ATrue
- BFalse
44Big data refers to data that are of large volumes and are unstructured.
- ATrue
- BFalse
45A sale is an example of an event in the REA accounting framework.
- ATrue
- BFalse
Information
- Description
- Quiz on Chapter 7, created by Rebecca Escobar on 06/11/2016.
- Author
- Rebecca Escobar
- Language
- English
- Views
- 10
- Tags
- Rating
- No ratings yet Rate this quiz