Assignment
Question 1
The purpose of using validation tests in the record definition of a database is to:
verify that the user is authorized to enter data in the database.
make sure the database works properly.
avoid data entry errors.
ensure normalized data.
Question 2
Reports enable users to:
limit the distribution of the information.
see a paper output of database information.
change information in the underlying database tables.
tab from one data field to another at run time.
Question 3
In the E-R model, the primary record key of a file is indicated by:
using a square.
printing the term (e.g., part number) in italics.
an asterisk.
underlining.
Question 4
Assume that an accounts receivable application contains database tables for customer orders, inventory items, customers, and salespersons. Which of these items would probably be a foreign key in the customer orders table?
Order number
Customer name
Salesperson number
All of these
Question 5
In the E-R model, an oval denotes a(n):
transitive relationship.
"is a" characteristic.
one-to-many relationship.
data attribute such as a social security number.
Question 6
The value that a database will use if the user does not provide an alternate value is called a(n):
text value.
control value.
default value.
asset value.
Question 7
In the REA framework, an account receivable would be classified as a(n):
Resource
Asset
Event
None of these
Question 8
A rule of thumb in industry is that the cost to correct an error in a database is approximately how many times the cost of entering the data initially?
5
7
10
3
Question 9
To perform a range test on the hours worked data field in an Access database that requires the entry to be at least 0 and no more than 40, you should express this requirement as:
between 0 And 40.
none of these.
at least 0; Not more than 40.
0<= X <= 40.
Question 10
Manual forms, in terms of database form design, are:
archaic.
used to collect information electronically.
used to guide the development of electronic forms.
used by many offices already.