Deck 15: Data Modeling and Database Design

Question 1

In the REA data modeling technique,the identifiable objects that have economic value to the organization are called

A)resources.
B)assets.
C)entities.
D)objects.

Answer 1

A

Question 2

Accountants should be involved in __________ aspect(s)of the database design process.

A)only the physical modeling
B)all
C)only the data flow diagram
D)only the requirements analysis

Answer 2

B

Question 3

An E-R diagram

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

Answer 3

A

Question 4

Events must be linked to at least one

A)Account
B)Agent
C)Entity
D)Resource

Question 5

An example of an event is

A)employees
B)customers
C)sales
D)cash

Question 6

Events must be linked to at least two

A)Agents
B)Entities
C)Events
D)Resources

Question 7

The REA data model

A)Is used in many areas of business and science.
B)Was developed solely for use in designing accounting information systems.
C)Classifies data into relationships,entities and accounts.
D)All of the above.

Question 8

An example of a resource is

A)employees
B)customers
C)sales
D)cash

Question 9

An example of an agent is

A)customer
B)sales
C)cash
D)inventory

Question 10

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

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

Question 11

An E-R diagram

A)only depicts the contents of a database.
B)only graphically models an organization.
C)only defines a database so that it represents all aspects of the organization.
D)depicts both the contents of a database and graphically models an organization.

Question 12

The __________ in the REA model include all of the organization's business activities.

A)resources
B)events
C)agents
D)entities

Question 13

An E-R diagram represents entities as __________ and the relationships between them as lines and __________.

A)circles; squares
B)squares; diamonds
C)rectangles; diamonds
D)rectangles; circles

Question 14

Which of the following is not one of the rules that describe how the three types of entities should relate to one another in an REA data model?

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 15

Accountants may provide the greatest value to their organization by taking responsibility for data modeling.In which stage(s)of the database design process does data modeling occur?

A)only in the systems analysis stage
B)only in the design stage
C)in both the systems analysis and design stages of database design
D)neither the systems analysis nor the design stages of database design

Question 16

A(n)__________ diagram graphically depicts a database's contents by showing entities and relationships.

A)DFD
B)flowchart
C)E-R
D)REA

Question 17

The groups of people about which an organization collects data to help it better plan,control,and evaluate performance of its basic business activities are the

A)employees.
B)events.
C)agents.
D)entities.

Question 18

What does the acronym REA mean?

A)resources,events,agents
B)resources,entities,agents
C)relations,events,agents
D)relations,entities,agents

Question 19

There are five basic stages in the database design process.The step which includes developing the conceptual-,external-,and internal-level schema into the actual database structures is known as

A)stage one.
B)stage two.
C)stage three.
D)stage four.

Question 20

An entity-relationship diagram (E-R)is useful because it shows the various entities being modeled and the important relationships among them.Anything about which the organization wants to collect and store information is called

A)a data model.
B)an entity.
C)a schema.
D)a tuple.

Question 21

The "give" event represents an activity which

A)includes a promise to engage in future economic exchanges.
B)increases the organization's stock of an economic resource.
C)reduces the organization's stock of a resource that has economic value
D)none of the above.

Question 22

Which is a true statement about the REA data model?

A)The REA data model classifies entities into three distinct categories.
B)The term REA is an acronym that stands for resources,entities,and agents.
C)Using an REA data model is not helpful when creating an R-E diagram.
D)The "E" in the REA data model stands for things that have an economic value to the organization.

Question 23

Each event in an REA model will in most cases have at least one __________ agent and one __________ agent involved with the event.

A)internal; resource
B)external; entity
C)internal; employee
D)internal; external

Question 24

Nonfinancial information should be collected because

A)it may indicate events that may affect resources.
B)it can be used to plan other activities.
C)it can be used in transaction processing.
D)both A and B

Question 25

Relationships that affect the quantity of a resource are sometimes referred to as _______ relationships.

A)commitment
B)exchange
C)stockflow
D)none of the above

Question 26

The measure of how many instances of the other entity can be linked to one specific instance of a given entity is called

A)a resource.
B)a cardinality.
C)an agent.
D)an exchange event.

Question 27

Concerning the development of an REA model,which of the following statements is true?

A)Events that pertain to the entry of data are included in the REA model.
B)The objective is to model the basic value-chain activity.
C)REA diagrams model individual transactions and data collections.
D)Information retrieval events are modeled as events in the REA model.

Question 28

Developing an REA diagram for a specific transaction cycle consists of steps.The third step involves

A)Identifying events
B)Identifying agents
C)Identifying resources
D)Identifying cardinalities of each relationship

Question 29

Developing an REA diagram for a specific transaction cycle consists of steps.The second step involves

A)Identifying agents
B)Identifying resources
C)Identifying cardinality
D)Both a and b

Question 30

Developing an REA diagram for a specific transaction cycle consists of steps.The first step involves

A)Identifying events
B)Identifying agents
C)Identifying resources
D)Identifying cardinality

Question 31

The "get" event represents an activity which

A)includes a promise to engage in future economic exchanges.
B)increases the organization's stock of an economic resource.
C)reduces the organization's stock of a resource that has economic value
D)none of the above.

Question 32

Concerning cardinality,which of the following is false?

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.
D)The maximum cardinality can be zero.

Question 33

The maximum cardinality of a relationship in a REA diagram can be either

A)zero or one.
B)one or many.
C)zero or many.
D)none of the above

Question 34

The REA data model supports both __________ and __________ types of data.

A)financial; nonfinancial
B)logical; physical
C)planning; control
D)traditional; nontraditional

Question 35

The minimum cardinality of a relationship in an REA diagram can be either

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

Question 36

Developing an REA diagram for a specific transaction cycle consists of how many steps?

A)one
B)two
C)three
D)four

Question 37

Concerning cardinality,which of the following is true?

A)The three basic types of relationship between entities are identified by their minimum cardinality.
B)The choice of cardinalities is arbitrary.
C)The minimum cardinality is generally given last.
D)Cardinality information is the final step in drawing an REA diagram

Question 38

In an REA diagram,the pair of numbers next to each entity represents the cardinalities for the entity.The first number in the pair is known as

A)the minimum cardinality.
B)the maximum cardinality.
C)the x axis cardinality.
D)the y axis cardinality.

Question 39

Using the REA data model,promises to engage in future economic exchanges are called

A)commitments.
B)economic exchanges.
C)resources.
D)agents.

Question 40

An REA diagram must link every event to at least one __________ and two __________.

A)resource; agents
B)agent; resources
C)transaction; entities
D)resource; relationships

Question 41

Which type of transaction is represented by the diagram below?

A)Cash and carry consumer retail sales
B)Consumer retail sales paid in installments to the seller
C)Business to business sales of nondurable goods
D)Business that allows customers to carry a balance and make installment payments

Question 42

Data modeling is an element of

A)Systems analysis
B)Conceptual design
C)Both A and B
D)None of the above

Question 43

Developing an REA model involves three steps.In which step are the agents identified?

A)First
B)Second
C)Third
D)None of the above

Question 44

Which of the following is not one of the five stages of database design?

A)systems analysis
B)conceptual design
C)data modeling
D)implementation

Question 45

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

A)An automobile salvage business holds weekly auctions at which it sells its entire inventory.
B)A grocery store sells products to consumers.
C)A hobbyist restores antique cars.When a car is finished,she sells it on Ebay.
D)A firm sells movies to consumers through an online downloading service.

Question 46

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

A)
B)
C)
D)

Question 47

Concerning REA diagrams,which of the following is false?

A)Each organization will have its own unique REA diagram.
B)An REA diagram for a given organization will change over time.
C)Data modeling and REA diagram development involve complex and repetitive processes.
D)Redrawing an REA diagram several times during development is uncommon.

Question 48

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

A)
B)
C)
D)

Question 49

How many types of relationships are possible between entities?

A)one
B)two
C)three
D)an infinite number

Question 50

Assume the cardinalities associated in a relationship all have zero minimums and N maximums.This would be an example of which cardinality rule?

A)agent-event relationship
B)resource-event relationship
C)event-event relationship
D)none of the above relationships

Question 51

Which type of transaction is represented by the diagram below?

A)An automobile salvage business holds weekly auctions at which it sells its entire inventory.
B)A grocery store sells products to consumers.
C)A hobbyist restores antique cars.When a car is finished,she sells it on Ebay.
D)A firm sells movies to consumers through an online downloading service.

Question 52

A one-to-many relationship exists between entities when the maximum cardinality of one entity is __________ and the maximum cardinality for the other entity in that relationship is __________.

A)1; 1
B)1; N
C)M; N
D)M; M

Question 53

The REA model classifies entities into three basic categories.Which of the following is one of these three?

A)resources
B)relationships
C)accounting
D)entities

Question 54

Which type of transaction is represented by the diagram below?

A)An automobile salvage business holds weekly auctions at which it sells its entire inventory.
B)A grocery store sells products to consumers.
C)A hobbyist restores antique cars.When a car is finished,she sells it on Ebay.
D)A firm sells movies to consumers through an online downloading service.

Question 55

Cardinalities reflect __________ about the organization being modeled and its business practices.

A)assumptions
B)opinions
C)facts
D)theories

Question 56

Which type of transaction is represented by the diagram below?

A)An automobile salvage business holds weekly auctions at which it sells its entire inventory.
B)A grocery store sells products to consumers.
C)A hobbyist restores antique cars.When a car is finished,she sells it on Ebay.
D)A firm sells movies to consumers through an online downloading service.

Question 57

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

A)
B)
C)
D)

Question 58

Which type of transaction is represented by the diagram below?

A)Cash and carry consumer retail sales
B)Consumer retail sales paid in installments to the seller
C)Business to business sales of nondurable goods
D)Business that allows customers to carry a balance and make installment payments

Question 59

Which type of transaction is represented by the diagram below?

A)Cash and carry consumer retail sales
B)Consumer retail sales paid in installments to the seller
C)Business to business sales of nondurable goods
D)Business that allows customers to carry a balance and make installment payments

Question 60

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

A)
B)
C)
D)

Question 61

Describe the possible relationships between entities in terms of cardinalities.

Question 62

Which type of transaction is represented by the diagram below?

A)Vendors send a bill for each inventory item purchased which is payable on receipt.
B)A single purchase of inventory is paid for with multiple payments.
C)Inventory vendors send a monthly bill for merchandise delivered.The seller does not accept or allow installment payments.
D)Some inventory purchases are paid for with multiple payments and some payments may apply to multiple purchases.

Question 63

Explain how an AIS system can be viewed as a set of "give-to-get" exchanges.

Question 64

Which type of transaction is represented by the diagram below?

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 65

Which type of transaction is represented by the diagram below?

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

Which type of transaction is represented by the diagram below?

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

Which type of transaction is represented by the diagram below?

A)Vendors send a bill for each inventory item purchased which is payable on receipt.
B)A single purchase of inventory is paid for with multiple payments.
C)Inventory vendors send a monthly bill for merchandise delivered.The seller does not accept or allow installment payments.
D)Some inventory purchases are paid for with multiple payments and some payments may apply to multiple purchases.

Question 68

What is an REA data model?

Question 69

Define minimum and maximum cardinalities.

Question 70

Name and describe the three parts of the REA data model.

Question 71

Define cardinality.

Question 72

What are the three steps in developing an REA diagram?

Question 73

Which type of transaction is represented by the diagram below?

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

List the five stages in the database design process.

Question 75

Comment on the statement,"Accountants can and should participate in all stages of the database design process."

Question 76

Identify the three basic rules that apply to the REA model pattern.

Question 77

Which type of transaction is represented by the diagram below?

A)Vendors send a bill for each inventory item purchased which is payable on receipt.
B)A single purchase of inventory is paid for with multiple payments.
C)Inventory vendors send a monthly bill for merchandise delivered.The seller does not accept or allow installment payments.
D)Some inventory purchases are paid for with multiple payments and some payments may apply to multiple purchases.

Question 78

Which type of transaction is represented by the diagram below?

A)Cash and carry consumer retail sales
B)Consumer retail sales paid in installments to the seller
C)Business to business sales of nondurable goods
D)Business that allows customers to carry a balance and make installment payments

Question 79

What is data modeling?

Question 80

Using [Min,Max] notation,cardinality is represented by the following diagram.Which of the diagrams below correspond to the diagram?

A)
B)
C)
D)