Question 1

The letter "M" in the acronym DBMS stands for "maintenance."

Accepted Answer

The letter "M" in the acronym DBMS stands for "management," not maintenance. Therefore, option B is the correct answer.

Question 2

A Social Insurance Number SIN)is a good example of a useful primary record key.

Accepted Answer

A Social Insurance Number (SIN) is unique to each individual, making it an effective primary key for identifying records in a database.

Question 3

An accounting information system database is a collection of facts and figures that serves the accounting information needs of one or more organizational subsystems.

Accepted Answer

A database in an accounting information system contains information that is relevant to various subsystems within an organization, such as general ledger, accounts payable, and accounts receivable. This helps to ensure that different parts of the organization have access to the information they need to make informed decisions and perform their specific tasks.

Question 4

Record keys on computer files are unique only to the extent that they classify computer records by some general category.

Accepted Answer

Record keys on computer files are unique to identify a specific record or data item within a file or database. It is not just for classifying records by some general category.

Question 5

A computer record is used to store all the information about one transaction, but several such records must be used to store the information about one employee, one inventory part, and so forth, on a master file.

Accepted Answer

The answer of A computer record is used to store...

Question 6

The largest unit of information in an accounting information database is a data field.

Accepted Answer

The largest unit of information in an accounting information database is a record, which contains multiple data fields.

Question 7

The data field that distinguishes one record from another in a database table is called the primary key.

Accepted Answer

The primary key is a unique value that identifies each record in a database table. It is used to enforce data integrity and ensure that each record can be uniquely identified.

Question 8

The correct order of elements, from smallest to largest, in the data hierarchy is database, data field, record, file table).

Accepted Answer

The correct order of elements, from smallest to largest, in the data hierarchy is data field, record, file table, database.

Question 9

The letter "M" in the acronym DBMS stands for "management."

Accepted Answer

The letter "M" in DBMS stands for "management." DBMS stands for "Database Management System."

Question 10

The basic unit of information in an accounting information system database is the debit.

Accepted Answer

The basic unit of information in an accounting information system database is the transaction, which includes both a debit and a credit. Debits and credits are used to record changes in account balances, but they are not standalone units of information.

Question 11

The correct order of elements, from smallest to largest, in the data hierarchy is data field, record, file table), database.

Accepted Answer

The correct order of elements in the data hierarchy, from smallest to largest, is data field, record, file, database.

Question 12

Given the flexibility and usefulness of computerized accounting databases, a company will always find it cost effective to use them in processing, storing, and retrieving accounting data.

Accepted Answer

While computerized accounting databases offer significant advantages in processing, storing, and retrieving data, they may not always be cost-effective for every company, especially small businesses with limited budgets or those with simple accounting needs. The initial setup, maintenance costs, and training can be prohibitive for some companies.

Question 13

The smallest unit of information in the data hierarchy is a data field.

Accepted Answer

A data field is the smallest unit of data in the data hierarchy. It consists of a single piece of information, such as a name, number, or date.

Question 14

The basic unit of information in an accounting information database is a table.

Accepted Answer

The basic unit of information in an accounting information database is a record, which is a collection of related data elements stored in fields within a table.

Question 15

Three database concerns when creating large databases are "data integrity," "processing accuracy," and "data security."

Accepted Answer

Data integrity ensures that the data in the database is accurate and consistent. Processing accuracy ensures that the data is processed correctly and reliably. Data security ensures that the data is protected from unauthorized access, modification, or destruction. These are all important considerations when creating large databases.

Question 16

The correct order of elements, from smallest to largest, in the data hierarchy is data field, file table), record, database.

Accepted Answer

The correct order from smallest to largest is data field, record, file (table), database.

Question 17

The largest unit of information in the data hierarchy is a record.

Accepted Answer

The largest unit of information in the data hierarchy is a database or file, which contains multiple records.

Question 18

A foreign key is a data field in the records of one file that references a primary key in the records of another file.

Accepted Answer

This is the correct definition of a foreign key.

Question 19

For a file of employee workers, it would make more sense to use their last name as a primary key rather than their Social Insurance Number because this would better preserve their privacy.

Accepted Answer

A Social Insurance Number is a unique identifier for each individual, making it a more suitable primary key than a last name, which is not unique and could lead to data integrity issues.

Question 20

A last name such as "Smith" is an example of a useful primary record key.

Accepted Answer

A last name like "Smith" is not a good primary record key because it is not unique; many people can have the same last name, leading to potential confusion and errors in a database system.

Quiz 3: Data Modeling