ais ch4 part 3

Creating an empty table in a relational database requires use of the ________, and populating that table requires the use of ________. A) DDL; DML B) DQL; SQL C) DDL; DQL D) DML; DDA

a

Dana Halsey is chair of the Purebred Marmoset Society, which maintains a database of registered purebred marmosets and their breeding history. One table will store the name, birth date, and other characteristics of all of the marmosets that have been registered. Each marmoset is uniquely identified by a registration number. A second table will contain data that link each marmoset to its male and female parents by means of their registration numbers. The entities described by the first table are: A) marmosets B) parental relationships C) registration numbers D) names

a

If a national sales tax were implemented, which language would be used to add a new field in the sales table to track the sales tax due? A) Data Definition Language B) Data Manipulation Language C) Data Query Language D) Data Update Language

a

In a relational database, requiring that every record in a table have a unique identifier is called the A) entity integrity rule. B) referential integrity rule. C) unique primary key rule. D) foreign key rule.

a

In a well-designed and normalized database, which of the following attributes would be a foreign key in a cash receipts table? A) Customer number B) Cash receipt date C) Remittance advice number D) Customer check number

a

Scuz Bootes has been doing custom choppers, piercings, and tattoos for over thirty years. His home and place of business is a garage in the harbor district of Seattle, Washington. He has meticulous records of every job he has ever done, carefully handwritten with the customer name and address, a description of the job, and an attached picture of the bike or body part before and after customization. His unique style has recently attracted the attention of national media after several celebrities sought him out and showcased his work. Business is booming. Consequently, Scuz has hired you to construct an accounting information system, beginning with the historical records. As you read through the records, you notice that some customer last names have different first names in different records. For example, R. Framington Farnsworth (custom chopper), Bob Farnsworth (tattoo), and Snake Farnsworth (tattoos and piercings) all seem to be the same person. You explain to Scuz that every customer must be identified by a unique customer number in the AIS. You are referring to the A) entity integrity rule. B) referential integrity rule. C) update anomaly. D) insert anomaly.

a

The abstract representation of the contents of a database is called the A) logical data model. B) data dictionary. C) physical view. D) schema.

a

The delete anomaly A) may result in unintentional loss of important data. B) is usually easily detected by users. C) restricts the addition of new records. D) prevents users from deleting outdated data from records or tables.

a

The potential inconsistency that could occur when there are multiple occurrences of a specific data item in a database is called the A) update anomaly. B) insert anomaly. C) inconsistency anomaly. D) delete anomaly.

a

The problem of changes (or updates) to data values in a database being incorrectly recorded is known as A) an update anomaly. B) an insert anomaly. C) a delete anomaly. D) a memory anomaly.

a

The update anomaly in file-based systems or unnormalized database tables A) occurs because of data redundancy. B) restricts addition of new fields or attributes. C) results in records that cannot be updated. D) is usually easily detected by users.

a

What is one potential drawback in the design and implementation of database systems for accounting? A) Double-entry accounting relies on redundancy as part of the accounting process but well-designed database systems reduce and attempt to eliminate redundancy. B) Relational DBMS query languages will allow financial reports to be prepared to cover whatever time periods managers want to examine. C) Relational DBMS provide the capability of integrating financial and operational data. D) Relational DBMS can accommodate multiple views of the same underlying data; therefore, tables storing information about assets can include data about both historical and replacement costs.

a

When the human resources manager wants to gather data about vacation and personal day usage by employees and by departments, the manager would use which language? A) Data Query Language B) Data Manipulation Language C) Data Report Language D) Data Definition Language

a

A relational database in which customer data is not maintained independently of sales invoice data will most likely result in A) an update anomaly. B) an insert anomaly. C) a delete anomaly. D) an integrity anomaly.

b

Chelsana Washington is a medical equipment sales representative. Her company has provided her with a laptop computer that uses wireless connectivity to access the accounting information system from virtually anywhere in the country. She, and the other sales reps, have access to view customer and product information. They have access that allows them to enter and cancel customer orders. The permissions for the sales reps define a(an) ________ in the company's database management system. A) conceptual-level schema B) external-level schema C) data dictionary D) physical view

b

Dana Halsey is chair of the Purebred Marmoset Society, which maintains a database of registered purebred marmosets and their breeding history. One table will store the name, birth date, and other characteristics of all of the marmosets that have been registered. Each marmoset is uniquely identified by a registration number. A second table will contain data that link each marmoset to its male and female parents by means of their registration numbers. The entities described by the second table are: A) marmosets B) parental relationships C) registration numbers D) names

b

Dana Halsey is chair of the Purebred Marmoset Society, which maintains a database of registered purebred marmosets and their breeding history. One table will store the name, birth date, and other characteristics of all of the marmosets that have been registered. Each marmoset is uniquely identified by a registration number. A second table will contain data that link each marmoset to its male and female parents by means of their registration numbers. The primary key in the first table is: A) name B) registration number C) date of birth D) relationship number

b

Heidi Holloway is a headhunter with Career Funnel in Boca Raton, Florida. Heidi is proud of the company's motto: We funnel workers into jobs. The foundation of CF's success is its accounting information system. When a client is placed with an employer, a record is created that identifies the employment relationship. CF follows up on placements by surveying both employers and clients about the employment experience and then entering the results into the AIS. Clients are uniquely identified by social security number. In records that contain client survey data,the social security number number is likely to be A) the primary key. B) a foreign key. C) combined with other data fields to form a primary key. D) null.

b

In a well-structured database, the constraint that ensures the consistency of the data is known as the A) entity integrity rule. B) referential integrity rule. C) logical view. D) consistency integrity rule.

b

Inability to add new data to a database without violating the basic integrity of the database is referred to as the A) update anomaly. B) insert anomaly. C) integrity anomaly. D) delete anomaly.

b

The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the A) entity integrity rule. B) referential integrity rule. C) rule of keys. D) foreign key rule.

b

Dana Halsey is chair of the Purebred Marmoset Society, which maintains a database of registered purebred marmosets and their breeding history. One table will store the name, birth date, and other characteristics of all of the marmosets that have been registered. Each marmoset is uniquely identified by a registration number. A second table will contain data that link each marmoset to its male and female parents by means of their registration numbers. The primary key in the first table is: A) name B) birth date C) a foreign key in the second table. D) the primary key in the second table.

c

Dana Halsey is chair of the Purebred Marmoset Society, which maintains a database of registered purebred marmosets and their breeding history. One table will store the name, birth date, and other characteristics of all of the marmosets that have been registered. Each marmoset is uniquely identified by a registration number. A second table will contain data that link each marmoset to its male and female parents by means of their registration numbers. The primary key in the second table is: A) name B) birth date C) a combination of primary keys in the first table D) the same as the primary key in the first table

c

Identify the aspect of a well-structured database that is incorrect. A) Data is consistent. B) Redundancy is minimized and controlled. C) All data is stored in one table or relation. D) The primary key of any row in a relation cannot be null.

c

In the database design approach known as normalization, the first assumption made about data is A) there is no redundancy in the data. B) the delete anomaly will not apply since all customer records will be maintained indefinitely. C) everything is initially stored in one large table. D) the data will not be maintained in 3NF tables.

c

Scuz Bootes has been doing custom choppers, piercings, and tattoos for over thirty years. His home and place of business is a garage in the harbor district of Seattle, Washington. He has meticulous records of every job he has ever done, carefully handwritten with the customer name and address, a description of the job, and an attached picture of the bike or body part before and after customization. His unique style has recently attracted the attention of national media after several celebrities sought him out and showcased his work. Business is booming. Consequently, Scuz has hired you to construct an accounting information system, beginning with the historical records. As you read through the records, you notice that some customer last names have different first names in different records. For example, R. Framington Farnsworth (custom chopper), Bob Farnsworth (tattoo), and Snake Farnsworth (tattoos and piercings) .... all seem to be the same person. This is an example of what type of problem in the existing records? A) Entity integrity B) Referential integrity C) Update anomaly D) Insert anomaly

c

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly. A) purge B) erase C) delete D) integrity

c

Dana Halsey is chair of the Purebred Marmoset Society, which maintains a database of registered purebred marmosets and their breeding history. One table will store the name, birth date, and other characteristics of all of the marmosets that have been registered. Each marmoset is uniquely identified by a registration number. A second table will contain data that link each marmoset to its male and female parents by means of their registration numbers. The primary key in the second table is: A) name B) registration number C) date of birth D) relationship number

d

Scuz Bootes has been doing custom choppers, piercings, and tattoos for over thirty years. His home and place of business is a garage in the harbor district of Seattle, Washington. He has meticulous records of every job he has ever done, carefully handwritten with the customer name and address, a description of the job, and an attached picture of the bike or body part before and after customization. His unique style has recently attracted the attention of national media after several celebrities sought him out and showcased his work. Business is booming. Consequently, Scuz has hired you to construct an accounting information system, beginning with the historical records. ...As you read through the records, you notice that some describe multiple services. For example, Sheila Yasgur (notation: won lottery) got a custom chopper, multiple tattoos, and piercings in undisclosed locations (no pictures.) You realize that, in these cases, .... a single written record will have to be translated into multiple sales records. This is an example of what type of problem in the existing records? A) Entity integrity B) Referential integrity C) Update anomaly D) Insert anomaly

d

Scuz Bootes has been doing custom choppers, piercings, and tattoos for over thirty years. His home and place of business is a garage in the harbor district of Seattle, Washington. He has meticulous records of every job he has ever done, carefully handwritten with the customer name and address, a description of the job, and an attached picture of the bike or body part before and after customization. His unique style has recently attracted the attention of national media after several celebrities sought him out and showcased his work. Business is booming. Consequently, Scuz has hired you to construct an accounting information system, beginning with the historical records. You begin development of the relational database that will form the core of the AIS by envisioning the record stored in a single table with a column that represents each attribute. You then begin to break this table down into smaller tables. This process is called A) integration. B) optimization. C) minimization. D) normalization.

d

The database design method in which a designer uses knowledge about business processes to create a diagram of the elements to be included in the database is called A) normalization. B) decentralization. C) geometric data modeling. D) semantic data modeling.

d

Which is probably the most immediate and significant effect of database technology on accounting? A) replacement of the double entry-system B) change in the nature of financial reporting C) elimination of traditional records such as journals and ledgers D) quicker access to and greater use of accounting information in decision-making

d

Which of the statements below is incorrect? A) Semantic data modeling facilitates the efficient design of databases. B) Semantic data modeling facilitates communicating with the intended users of the system. C) Semantic data modeling allows a database designer to use knowledge about business processes to design the database. D) Semantic data modeling follows the rules of normalization in the design of a database.

d

Which statement below is false regarding the basic requirements of the relational data model? A) Every column in a row must be single-valued. B) All non-key attributes in a table should describe a characteristic about the object identified by the primary key. C) Foreign keys, if not null, must have values that correspond to the value of a primary key in another table. D) Primary keys can be null.

d