Question 1

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

Accepted Answer

A schema describes the logical structure

Question 2

Helen Fume is a recruiter with The Ladders in Nome,Alaska.The Ladders success is largely attributable to its accounting information system.When a client is hired by an employer,Helen creates a record that identifies the employment relationship.Helen 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 is likely to be

Accepted Answer

A) the primary key. 
B) a foreign key. 
C) combined with other data fields to form a primary key. 
D) null. 
A) the primary key. 
B) a foreign key. 
C) combined with other data fields to form a primary key. 
D) null.

Question 3

Which of the following would not be found in a data dictionary entry for a data item?

Accepted Answer

A) records containing a specific data item 
B) physical location of the data 
C) source of the data item 
D) field type 
A) records containing a specific data item 
B) physical location of the data 
C) source of the data item 
D) field type

Question 4

Using the database depicted below,how many foreign keys are in the database?

Accepted Answer

A) 0 
B) 3 
C) 4 
D) 5 
A) 0 
B) 3 
C) 4 
D) 5

Question 5

Explain the two advantages semantic data modeling has over normalization when designing a relational database.

Accepted Answer

Semantic data modeling takes advantage o

Question 6

Ama Afolayan is chair of the National Owl Society,which maintains a database of all rare owls within the United States.One table will store the name,birth date,and other characteristics of all of the owls that have been registered.Each owl is uniquely identified by a registration number.A second table will contain data that link each owl to its male and female parents by means of their registration numbers.The entities described by the second table are

Accepted Answer

A) owls. 
B) parental relationships. 
C) registration numbers. 
D) names. 
A) owls. 
B) parental relationships. 
C) registration numbers. 
D) names.

Question 7

A low-level view of the database that describes how the data are actually stored and accessed is the

Accepted Answer

A) conceptual-level schema. 
B) subschema. 
C) internal-level schema. 
D) external-level schema. 
A) conceptual-level schema. 
B) subschema. 
C) internal-level schema. 
D) external-level schema.

Question 8

Inability to add new data to a database without violating the basic integrity of the database is referred to as the

Accepted Answer

A) update anomaly. 
B) insert anomaly. 
C) integrity anomaly. 
D) delete anomaly. 
A) update anomaly. 
B) insert anomaly. 
C) integrity anomaly. 
D) delete anomaly.

Question 9

When the human resources manager wants to gather data about salary and start date by employees and by departments,the manager would use which language?

Accepted Answer

A) Data Manipulation Language 
B) Data Query Language 
C) Data Report Language 
D) Data Definition Language 
A) Data Manipulation Language 
B) Data Query Language 
C) Data Report Language 
D) Data Definition Language

Question 10

Cornelia Cassidy is a telecom 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 has access to view customer and product information.She also has access that allows her to enter and cancel customer orders.The permissions for Cornelia (and other sales reps)define a ________ in the company's database management system.

Accepted Answer

A) conceptual-level schema 
B) data dictionary 
C) external-level schema 
D) physical view 
A) conceptual-level schema 
B) data dictionary 
C) external-level schema 
D) physical view

Question 11

Describe a data dictionary.

Accepted Answer

A data dictionary is a means by which in

Question 12

The ________ is responsible for the database.

Accepted Answer

A) database master 
B) database manager 
C) database administrator 
D) data coordinator 
A) database master 
B) database manager 
C) database administrator 
D) data coordinator

Question 13

Explain the types of attributes that tables possess in a relational database.

Accepted Answer

Primary key - the attribute,or combinati

Question 14

Databases were originally developed to address which problem?

Accepted Answer

A) to replace the double entry-system 
B) to address the proliferation of master files 
C) to increase the speed that an organization could process transactions 
D) to decrease the costs associated with manual accounting systems 
A) to replace the double entry-system 
B) to address the proliferation of master files 
C) to increase the speed that an organization could process transactions 
D) to decrease the costs associated with manual accounting systems

Question 15

Kai Keoni has created custom statues made out of scrap metal for over ten years.He lives above his shop in Martha's Vineyard,Maryland.Kai is an accounting fanatic and has kept detailed records of every statue he has ever created.For every sale,he obtains the customer's name and address,a description of the statue,and a picture of the statue sold to the customer.His unique style has recently attracted the attention of several celebrities.Ready to take his business to the next level,Kai has hired you to construct an accounting information system,which he wants modeled after his paper records.As you look over his records,you realize that sometimes the same customer is recorded by a slightly different name.For example,Mike Mulligan bought a horse statue,M.Mulligan bought a pig statue,and Mike M.all seem to be the same person.This is an example of what type of problem in the existing records?

Accepted Answer

A) entity integrity 
B) referential integrity 
C) update anomaly 
D) insert anomaly 
A) entity integrity 
B) referential integrity 
C) update anomaly 
D) insert anomaly

Question 16

Which of the following would not be true about the well-structured tables in a well-designed relational database used to generate this sales invoice?

Accepted Answer

A) Quantity would be generated from the Sales table. 
B) 34567 would be a primary key in the Sales table. 
C) Unit Price would be generated from the Inventory table. 
D) Hardware City is an example of a non-key data value in the Customer table. 
A) Quantity would be generated from the Sales table. 
B) 34567 would be a primary key in the Sales table. 
C) Unit Price would be generated from the Inventory table. 
D) Hardware City is an example of a non-key data value in the Customer table.

Question 17

Ama Afolayan is chair of the National Owl Society,which maintains a database of all rare owls within the United States.One table will store the name,birth date,and other characteristics of all of the owls that have been registered.Each owl is uniquely identified by a registration number.A second table will contain data that link each owl to its male and female parents by means of their registration numbers.The primary key in the second table is

Accepted Answer

A) name. 
B) birth date. 
C) the same as the primary key in the first table. 
D) a combination of primary keys in the first table. 
A) name. 
B) birth date. 
C) the same as the primary key in the first table. 
D) a combination of primary keys in the first table.

Question 18

Kekoa Konani is chairman of the Chatty Chihuahua Club,where he maintains a database of registered purebred Chihuahuas and their breeding history.One table will store the name,birth date,and other characteristics of all of the registered Chihuahuas.Each Chihuahua is uniquely identified by a registration number.A second table will contain data that link each Chihuahua to its male and female parents by means of their registration numbers.The primary key in the first table is

Accepted Answer

A) name. 
B) registration number. 
C) date of birth. 
D) relationship number. 
A) name. 
B) registration number. 
C) date of birth. 
D) relationship number.

Question 19

Ama Afolayan is chair of the National Owl Society,which maintains a database of all rare owls within the United States.One table will store the name,birth date,and other characteristics of all of the owls that have been registered.Each owl is uniquely identified by a registration number.A second table will contain data that link each owl to its male and female parents by means of their registration numbers.The primary key in the first table is

Accepted Answer

A) name. 
B) birth date. 
C) the primary key in the second table. 
D) a foreign key in the second table. 
A) name. 
B) birth date. 
C) the primary key in the second table. 
D) a foreign key in the second table.

Question 20

In the database design approach known as normalization,the first assumption made about data is

Accepted Answer

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. 
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.

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

Which of the following would not be found in a data dictionary entry for a data item?

Using the database depicted below,how many foreign keys are in the database?

Explain the two advantages semantic data modeling has over normalization when designing a relational database.

A low-level view of the database that describes how the data are actually stored and accessed is the

Inability to add new data to a database without violating the basic integrity of the database is referred to as the

When the human resources manager wants to gather data about salary and start date by employees and by departments,the manager would use which language?

Describe a data dictionary.

The ________ is responsible for the database.

Explain the types of attributes that tables possess in a relational database.

Databases were originally developed to address which problem?

Which of the following would not be true about the well-structured tables in a well-designed relational database used to generate this sales invoice?

In the database design approach known as normalization,the first assumption made about data is

Accounting Information Systems: an Overview

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Controls for Information Security

Confidentiality and Privacy Controls

Processing Integrity and Availability Controls

Auditing Computer-Based Information Systems

The Revenue Cycle: Sales to Cash Collections

The Expenditure Cycle: Purchasing to Cash Disbursements

The Production Cycle

The Human Resources Management and Payroll Cycle

General Ledger and Reporting System

Database Design Using the Rea Data Model

Implementing an Rea Model in a Relational Database

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design,implementation,and Operation

Filters

Exam 4: Relational Databases

Describe the different schemas involved in a database structure.What is the role of accountants in development of schemas?

Which of the following would not be found in a data dictionary entry for a data item?

Using the database depicted below,how many foreign keys are in the database?

Explain the two advantages semantic data modeling has over normalization when designing a relational database.

A low-level view of the database that describes how the data are actually stored and accessed is the

Inability to add new data to a database without violating the basic integrity of the database is referred to as the

When the human resources manager wants to gather data about salary and start date by employees and by departments,the manager would use which language?

Describe a data dictionary.

The ________ is responsible for the database.

Explain the types of attributes that tables possess in a relational database.

Databases were originally developed to address which problem?

Which of the following would not be true about the well-structured tables in a well-designed relational database used to generate this sales invoice?

In the database design approach known as normalization,the first assumption made about data is

Accounting Information Systems: an Overview

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Computer Fraud

Computer Fraud and Abuse Techniques

Control and Accounting Information Systems

Controls for Information Security

Confidentiality and Privacy Controls

Processing Integrity and Availability Controls

Auditing Computer-Based Information Systems

The Revenue Cycle: Sales to Cash Collections

The Expenditure Cycle: Purchasing to Cash Disbursements

The Production Cycle

The Human Resources Management and Payroll Cycle

General Ledger and Reporting System

Database Design Using the Rea Data Model

Implementing an Rea Model in a Relational Database

Special Topics in Rea Modeling

Introduction to Systems Development and Systems Analysis

Ais Development Strategies

Systems Design,implementation,and Operation

Filters