Chapter 19 - Quiz

Developing an REA diagram for a specific business cycle consists of which of the following step(s)? A.All of these are correct B.Identify the resources affected by each event and the agents who participate in those events. C.Determine the cardinalities of each relationship. D.Identify the events about which management wants to collect information.

A.All of these are correct

Which of the following statements are true? (Check all that apply.) A.An E-R diagram can be used to understand a database. B.None of these are correct. C.An E-R diagram can be used to document a database. D.An E-R diagram can be used to design a database.

A.An E-R diagram can be used to understand a database. C.An E-R diagram can be used to document a database. D.An E-R diagram can be used to design a database.

At which stage(s) of the database design process is the information needed to determine the cardinalities of relationships obtained? (Check all that apply.) A.Conceptual design B.Operation and Maintenance C.Implementation and Conversion D.Physical design E.Systems analysis

A.Conceptual design E.Systems analysis

Which of the following statements are true? (Check all that apply.) A.In a relational database, a table is created for each entity. B.In an object-oriented database, a class is created for each attribute. C.In an object-oriented database, a class is created for each entity. D.In a relational database, a table is created for each attribute.

A.In a relational database, a table is created for each entity. C.In an object-oriented database, a class is created for each entity.

Which of the following statements are true? (Check all that apply.) A.In an E-R diagram, attributes can be depicted as named ovals attached to entities B.In an E-R diagram, relationships can be depicted as a line between two entities C.In an E-R diagram, attributes can be depicted in a two-column table that is separate from the graphical diagram itself D.In an E-R diagram, relationships can be depicted as diamonds linked to two entities

A.In an E-R diagram, attributes can be depicted as named ovals attached to entities B.In an E-R diagram, relationships can be depicted as a line between two entities C.In an E-R diagram, attributes can be depicted in a two-column table that is separate from the graphical diagram itself D.In an E-R diagram, relationships can be depicted as diamonds linked to two entities

Which of the following statements are true? (Check all that apply.) A.In an REA diagram, each event is linked to at least one resource. B.In an REA diagram, each event is linked to at least one other event. C.In an REA diagram, each relationship is linked to at least one agent. D.In an REA diagram, each relationship is linked to at least one resource.

A.In an REA diagram, each event is linked to at least one resource. B.In an REA diagram, each event is linked to at least one other event.

Which of the following statements are true? (Check all that apply.) A.Information about resources is usually retained indefinitely (i.e., for many years). B.Information about resources, events, and agents is only retained for the current fiscal year. C.Information about events is usually retained indefinitely (i.e., for many years). D.Information about agents is usually retained indefinitely (i.e., for many years).

A.Information about resources is usually retained indefinitely (i.e., for many years). D.Information about agents is usually retained indefinitely (i.e., for many years).

In an E-R diagram, entities are represented as: A.Rectangles B.Diamonds C.Circles D.Lines

A.Rectangles

Which of the following is the first stage of the database design process? A.Systems analysis B.Physical design C.Conceptual design D.Conversion

A.Systems analysis

In which stage(s) of the database design process can accountants provided the greatest value to their organization? (Check all that apply.) A.Systems analysis B.Operation and Maintenance C.Physical design D.Implementation and Conversion E.Conceptual design

A.Systems analysis E.Conceptual design

Which is the correct sequence of steps in the database design process? A.Systems analysis, conceptual design, physical design, implementation and conversion, operation and maintenance B.Physical design, conceptual design, systems analysis, implementation and conversion, operation and maintenance C.None of these are correct D.Conceptual design, physical design, systems analysis, implementation and conversion, operation and maintenance

A.Systems analysis, conceptual design, physical design, implementation and conversion, operation and maintenance

Which of the following statements is not true? A.The minimum cardinality in a relationship in an REA diagram can be many. B.The minimum cardinality in a relationship in an REA diagram can be zero. C.The maximum cardinality in a relationship in an REA diagram can be one. D.The minimum cardinality in a relationship in an REA diagram can be one. E.The maximum cardinality in a relationship in an REA diagram can be many.

A.The minimum cardinality in a relationship in an REA diagram can be many.

In an REA diagram, the economic duality principle means that: A.every event entity must be linked to at least one other event entity. B.all three statements reflect the economic duality principle. C.every event entity must be linked to at least two participating agents. D.none of the statements reflect the economic duality principle.E.every event entity must be linked to at least one resource entity.

A.every event entity must be linked to at least one other event entity.

If it is optional whether a specific instance of entity A participates in a relationship with an instance of entity B, the minimum cardinality for entity A in this relationship is A.zero. B.one. C.many. D.None of these are correct.

A.zero.

In an REA diagram, what kind of entity is "Employee"? A.Resource B.Agent C.Event D.None of these are correct

B.Agent

Which kind of entity in an REA diagram would contain information about business activities performed by an organization? A.Resource B.Event C.Agent D.None of these are correct

B.Event

At what stage(s) in the database design process is a data model used? (Check all that apply.) A.Conceptual design B.Implementation and conversion C.Operation and maintenance D.Physical design E.Systems analysis

B.Implementation and conversion C.Operation and maintenance D.Physical design

Which of the following statements is true? A.The minimum cardinality is used to indicate whether an entity can be linked to only one or more than one instance of another entity. B.None of these are correct C.The minimum cardinality can be either one or many.D.The maximum cardinality is used to indicate whether the relationship between two entities is optional or mandatory.E.The maximum cardinality can be either zero or one.

B.None of these are correct

In which stage of the database design process are user information needs identified and the scope of the proposed new system defined? A.Conceptual design B.Systems analysis C.Physical design D.None of these are correct

B.Systems analysis

Which statement is true? A.The choice of cardinalities in an REA diagram is arbitrary. B.The choice of cardinalities in an REA diagram reflects facts about the organization's business practices. C.None of these are true. D.The choice of cardinalities in an REA diagram depends upon the wishes of the data modeler.

B.The choice of cardinalities in an REA diagram reflects facts about the organization's business practices.

Which of the following statements are true? (Check all that apply.) A.Typically, REA diagrams depict that the minimum cardinality on the agent side of an event-agent relationship must be zero. B.Typically, the relationship between agents and events is 1:N C.Typically, the relationship between agents and events is M:N D.Typically, REA diagrams depict that the minimum cardinality on the event side of an event-agent relationship must be one.

B.Typically, the relationship between agents and events is 1:N

In an E-R diagram, relationships are depicted as A.ovals. B.diamonds. C.inverted triangles. D.rectangles.

B.diamonds.

If an instance of entity A can only be linked to one instance of entity B, the maximum cardinality for entity A in this relationship is A.zero. B.one. C.many. D.None of these are correct.

B.one.

If at least one instance of entity A must participate in a relationship with an instance of entity B, the minimum cardinality for entity A in this relationship is A.zero. B.one. C.many. D.None of these are correct.

B.one.

Which of the following is an entity? A.Customers B.Sales C.All of these are correct D.Purchases E.Suppliers

C.All of these are correct

At what stage(s) in the database design process is a data model created? (Check all that apply.) A.Operation and maintenance B.Physical design C.Conceptual design D.Implementation and conversion E.Systems analysis

C.Conceptual design E.Systems analysis

In an REA diagram, information about all the payments received from customers would be stored in which type of entity? A.Resource B.Agent C.Event D.None of these are correct

C.Event

In an REA diagram, what kind of entity is "Receive Cash"? A.Agent B.Resource C.Event D.None of these are correct

C.Event

In an REA diagram, information about the various cash accounts that an organization has (checking, payroll, savings, etc.) would be found in which type of entity? A.Event B.Agent C.Resource D.None of these are correct

C.Resource

If an instance of entity A can be linked to multiple instances of entity B, the maximum cardinality for entity A in this relationship is A.zero. B.one. C.many. D.None of these are correct.

C.many.

In an REA diagram, suppliers would be examples of the type of entity called a(n): A.Resource B.Event C.None of these are correct D.Agent

D.Agent

Which of the following statements is true? A.REA diagrams should be drawn by designers without involving end users. B.REA diagrams only describe what should happen, but not what actually happens. C.None of these are correct. D.Relationship cardinalities differ across companies because business practices differ across companies.

D.Relationship cardinalities differ across companies because business practices differ across companies.

Every employee at the Grizzley Corp can enroll in more than one training program, and each training program can have more than one employee to participate. Thus, the cardinality that exists between employee and training program is A.a many-to-one (M:1) relationship. B.a one-to-one (1:1) relationship. C.a one-to-many (1:N) relationship. D.a many-to-many (M:N) relationship.

D.a many-to-many (M:N)

In an REA model, activities about which management wants to collect information for planning or control purposes are known as A.resources. B.agents. C.activities. D.events.

D.events.

Cardinalities in an REA diagram _________ A.are the same for every organization. B.are chosen arbitrarily by the designer. C.None of these are correct. D.reflect the business practices of the organization.

D.reflect the business practices of the organization.