Question 1

Describe the possible relationships between entities,in terms of cardinalities.

Accepted Answer

There are three types or relationships p

Question 2

An entity-relationship diagram

Accepted Answer

A) can represent the contents of any database. 
B) is only used in conjunction with REA models. 
C) can show a limited number of entities and relationships. 
D) is used only to design new databases. 
A) can represent the contents of any database. 
B) is only used in conjunction with REA models. 
C) can show a limited number of entities and relationships. 
D) is used only to design new databases.

Question 3

Define cardinality.

Accepted Answer

The cardinality of the relationship indi

Question 4

________ includes all the activities associated with transferring data from existing systems to the new database AIS,testing the new system,and training employees how to use it.

Accepted Answer

A) Systems analysis 
B) Conceptual design 
C) Physical design 
D) Implementation and conversion 
A) Systems analysis 
B) Conceptual design 
C) Physical design 
D) Implementation and conversion

Question 5

Which of the following is not one of the rules in creating an REA data model?

Accepted Answer

A) Each event is linked to at least one resource that it affects. 
B) Each event is linked to at least one other event. 
C) Each event is linked to at least two participating agents. 
D) All of the above are important rules. 
A) Each event is linked to at least one resource that it affects. 
B) Each event is linked to at least one other event. 
C) Each event is linked to at least two participating agents. 
D) All of the above are important rules.

Question 6

In which stage(s)of the database design process does data modeling occur?

Accepted Answer

A) During the systems analysis stage. 
B) During the design stage. 
C) During both the systems analysis and design stages. 
D) After the design stage. 
A) During the systems analysis stage. 
B) During the design stage. 
C) During both the systems analysis and design stages. 
D) After the design stage.

Question 7

A dental office employs three dentists and five dental hygienists.One of the dentists is a very recent dental school graduate and can't yet see patients on her own until she passes boards and obtains a license.Dentists perform all procedures personally,except for regular cleaning and x-rays,which are performed exclusively by dental hygienists.Three of the five dental hygienists perform only regular cleaning and x-rays.The other two hygienists each assist a specific dentist during procedures,as well as performing regular cleaning and x-rays.One of the hygienists will be assigned to the new dentist when she begins seeing patients.Hygienists usually 'shadow' other hygienists and dentists for two weeks prior to seeing patients.
Patients schedule appointments directly with dentists and hygienists,depending on the type of dental service needed.Patients do not have to choose a dentist until they need service other than routine cleaning or x-rays.Patients are assigned to a specific dental hygienist when they schedule their first appointment.The customer master file has 549 records.Diagram the agents described,relationships between agents,and the cardinality pairs for each relationship.

Accepted Answer

The answer of A dental office employs three dentists and...

Question 8

The process of defining a database so that it faithfully represents all aspects of the organization including its interactions with the external environment is called

Accepted Answer

A) data modeling. 
B) data designing. 
C) data development. 
D) data definition. 
A) data modeling. 
B) data designing. 
C) data development. 
D) data definition.

Question 9

________ includes carefully monitoring system performance and user satisfaction to determine the need for making system enhancements and modifications.

Accepted Answer

A) Operation and maintenance 
B) Conceptual design 
C) Physical design 
D) Implementation and conversion 
A) Operation and maintenance 
B) Conceptual design 
C) Physical design 
D) Implementation and conversion

Question 10

Helge Autoparts sells new and refurbished auto parts exclusively to auto dealers.Helge purchases inventory from distributors at trade conventions.Each time Helge makes a purchase,the company records the suppliers name,address,date,specific items purchased,price paid for each,and the total amount spent.Helge later researches the inventory items to set the customer price.The company assigns an inventory number to each item purchased and records the customer price for each item.Helge buys price tags and display supplies from Alwin Incorporated,a company that sells them at all trade conventions.All inventory and supplies purchases are immediately paid for with cash or with checks from a bank account in Helge's name.All cash received from sales are also deposited to the same bank account.Several times a year Helge rents display space at dealer conventions.A deposit is always required,and the entire fee is due the day the convention starts.Helge records the deposit and final payment,along with the convention's name and address,in the same worksheet on which purchases of inventory and supplies are recorded. Consider Helge's processes regarding the purchasing inventory and supplies,renting display space,and paying for purchased items.A well-designed REA diagram would

Accepted Answer

A) reflect minimum cardinalities of 1 for the relationship between Vendor and Cash Disbursement entities. 
B) reflect the same number of 0 and 1 minimum cardinalities. 
C) reflect more maximum cardinalities of M than of 1. 
D) reflect maximum cardinalities of M for the relationship between Inventory and Purchase entities. 
A) reflect minimum cardinalities of 1 for the relationship between Vendor and Cash Disbursement entities. 
B) reflect the same number of 0 and 1 minimum cardinalities. 
C) reflect more maximum cardinalities of M than of 1. 
D) reflect maximum cardinalities of M for the relationship between Inventory and Purchase entities.

Question 11

Identify the minimum cardinality of any REA diagram relationship.

Accepted Answer

A) 0 or 1. 
B) 0 or N. 
C) 1 or N. 
D) none of the above. 
A) 0 or 1. 
B) 0 or N. 
C) 1 or N. 
D) none of the above.

Question 12

Which of the following statements about REA modeling and REA diagrams is false?

Accepted Answer

A) REA is an acronym for Resources, Entities, and Agents. 
B) REA data modeling does not include traditional accounting elements such as ledgers, chart of accounts, debits and credits. 
C) REA data modeling could be referred to as an events-based model. 
D) REA diagrams must include at least two activities, which together represent a give-get economic exchange. 
A) REA is an acronym for Resources, Entities, and Agents. 
B) REA data modeling does not include traditional accounting elements such as ledgers, chart of accounts, debits and credits. 
C) REA data modeling could be referred to as an events-based model. 
D) REA diagrams must include at least two activities, which together represent a give-get economic exchange.

Question 13

Identify the statement below that is false with respect to cardinalities.

Accepted Answer

A) Cardinalities describe the nature of the relationship between two entities. 
B) No universal standard exists for representing information about cardinalities in REA diagrams. 
C) The minimum cardinality can be zero or one. 
D) The maximum cardinality can be zero, one, or many. 
A) Cardinalities describe the nature of the relationship between two entities. 
B) No universal standard exists for representing information about cardinalities in REA diagrams. 
C) The minimum cardinality can be zero or one. 
D) The maximum cardinality can be zero, one, or many.

Question 14

Which of the following graphical symbols represents a minimum cardinality of one and a maximum cardinality of many?

Accepted Answer

A) 
  
B) 
  
C) 
  
D) 
  
A) 
  
B) 
  
C) 
  
D)

Question 15

Which of the following transactions is represented by the diagram below?

Accepted Answer

A) Each sale is associated with a single order, and there is a time lag between the time an order is taken and delivery of the product. 
B) Each sale can be comprised of multiple orders, and each order can be associated with multiple sales or no sales. 
C) Each sale can be comprised of multiple orders, and each order can be associated with one or more multiple sales. 
D) Each sale is associated with a single order and, there is no time lag between the time an order is taken and delivery of the product. 
A) Each sale is associated with a single order, and there is a time lag between the time an order is taken and delivery of the product. 
B) Each sale can be comprised of multiple orders, and each order can be associated with multiple sales or no sales. 
C) Each sale can be comprised of multiple orders, and each order can be associated with one or more multiple sales. 
D) Each sale is associated with a single order and, there is no time lag between the time an order is taken and delivery of the product.

Question 16

Identify the notation often used to represent cardinality information.

Accepted Answer

A) Dotted lines. 
B) Greek characters. 
C) Crow's feet. 
D) Color coding. 
A) Dotted lines. 
B) Greek characters. 
C) Crow's feet. 
D) Color coding.

Question 17

The first step in developing an REA diagram for a specific transaction cycle begins with identifying

Accepted Answer

A) relevant events. 
B) agents involved. 
C) resources affected. 
D) relationship cardinalities. 
A) relevant events. 
B) agents involved. 
C) resources affected. 
D) relationship cardinalities.

Question 18

What is the minimum number of agents that must participate in each REA event?

Accepted Answer

A) 0 
B) 2 
C) 1 
D) 3 
A) 0 
B) 2 
C) 1 
D) 3

Question 19

Explain why users should participate in data modeling?

Accepted Answer

Data modeling is not an easy task.The sa

Question 20

Describe an REA data model.

Accepted Answer

The REA data model is a conceptual model

Describe the possible relationships between entities,in terms of cardinalities.

An entity-relationship diagram

Define cardinality.

________ includes all the activities associated with transferring data from existing systems to the new database AIS,testing the new system,and training employees how to use it.

Which of the following is not one of the rules in creating an REA data model?

In which stage(s)of the database design process does data modeling occur?

The process of defining a database so that it faithfully represents all aspects of the organization including its interactions with the external environment is called

________ includes carefully monitoring system performance and user satisfaction to determine the need for making system enhancements and modifications.

Identify the minimum cardinality of any REA diagram relationship.

Which of the following statements about REA modeling and REA diagrams is false?

Identify the statement below that is false with respect to cardinalities.

Which of the following graphical symbols represents a minimum cardinality of one and a maximum cardinality of many?

Which of the following transactions is represented by the diagram below?

Identify the notation often used to represent cardinality information.

The first step in developing an REA diagram for a specific transaction cycle begins with identifying

What is the minimum number of agents that must participate in each REA event?

Explain why users should participate in data modeling?

Describe an REA data model.

Conceptual Foundations of Accounting Information Systems

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Relational Databases

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

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 17: Database Design Using the Rea Data Model

Describe the possible relationships between entities,in terms of cardinalities.

An entity-relationship diagram

Define cardinality.

________ includes all the activities associated with transferring data from existing systems to the new database AIS,testing the new system,and training employees how to use it.

Which of the following is not one of the rules in creating an REA data model?

In which stage(s)of the database design process does data modeling occur?

The process of defining a database so that it faithfully represents all aspects of the organization including its interactions with the external environment is called

________ includes carefully monitoring system performance and user satisfaction to determine the need for making system enhancements and modifications.

Identify the minimum cardinality of any REA diagram relationship.

Which of the following statements about REA modeling and REA diagrams is false?

Identify the statement below that is false with respect to cardinalities.

Which of the following graphical symbols represents a minimum cardinality of one and a maximum cardinality of many?

Which of the following transactions is represented by the diagram below?

Identify the notation often used to represent cardinality information.

The first step in developing an REA diagram for a specific transaction cycle begins with identifying

What is the minimum number of agents that must participate in each REA event?

Explain why users should participate in data modeling?

Describe an REA data model.

Conceptual Foundations of Accounting Information Systems

Overview of Transaction Processing and Enterprise Resource Planning Systems

Systems Documentation Techniques

Relational Databases

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

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