Deck 18: Implementing an Rea Model in a Relational Database

Question 1

In an integrated REA diagram,every event must be linked to

A)at least two resources.
B)at least two agents.
C)at least one other event.
D)at least two other events.

Answer 1

B

Question 2

In an integrated REA diagram,every resource must be linked to

A)at least two events.
B)at least two agents.
C)at least one other resource.
D)at least two other resources.

Answer 2

A

Question 3

Combining REA diagrams for individual transaction cycles into a single,enterprise-wide model adds three more rules to the three basic principles for drawing REA diagrams.Which of the following is not one of those two new rules?

A)Every resource must be linked to at least one event that increments that resource and to at least one event that decrements that resource.
B)If a specific event can be linked to more than one other type of event, but cannot be linked simultaneously to all of those other events, then the minimum cardinality between that event and every other event with which it may be associated must be 0.
C)If a specific event can be linked to more than one other type of event, but cannot be linked simultaneously to all of those other events, then the maximum cardinality between that event and every other event with which it may be associated must be 0.
D)All of the above are new rules for drawing integrated REA diagrams.

Answer 3

C

Question 4

Which of the statements below is false with respect to enterprise-wide REA diagrams?

A)Merging two or more REA diagrams that contain the same resource entity does not require any changes to the cardinality pairs in the individual diagrams.
B)Merging two or more diagrams that contain a common event entity, however, often requires changing the minimum cardinalities associated with the other events to 0, to reflect the fact that the merged event may be connected to any one of several different events, but not to all of them simultaneously.
C)The minimum cardinalities associated with agents may also have to be changed to 0.
D)All of the above are true.

Question 5

An integrated REA diagram merges multiple copies of some entities in order to

A)minimize the repetition of agent entities.
B)maximize the legibility of the diagram by avoiding the need to have relationship lines cross one another.
C)keep the diagram less complex.
D)maintain a clear representation of the activities that are represented by the diagram.

Question 6

In an integrated REA diagram,every agent must be linked to

A)at least one resource.
B)at least two resources.
C)at least one event.
D)at least two events.

Question 7

Which of the below statements is false with respect to REA diagrams for individual transaction cycles?

A)They depict basic give-to-get economic duality relationships.
B)They usually provide only a partial view of resources.
C)They need to be combined in order to provide a comprehensive enterprise-wide data model.
D)They show both how resources are acquired and how they are used.

Question 8

Describe the rules that are necessary to correctly draw an integrated REA diagram.

Question 9

When combining two REA diagrams by merging common entities,changes in the cardinality of the merged entity is needed when it is a(n)

A)agent.
B)event.
C)relationship.
D)resource.

Question 10

An integrated REA diagram merges multiple copies of ________ and ________ entities but retains multiple copies of ________ entities.

A)resource; event; agent
B)event; agent; resource
C)resource; agent; event
D)event; resource; agent

Question 11

An integrated REA diagram could contain multiple copies of

A)customers.
B)sales.
C)inventory.
D)sales-inventory.

Question 12

Which of the following is a redundant entity that would be merged when two cycles are combined?

A)Customer.
B)Employee.
C)Vendor.
D)Inventory.

Question 13

Which entity is most likely to be part of the payroll cycle,expenditure cycle,and the revenue cycle?

A)Customer.
B)Cash.
C)Supplier.
D)Inventory.

Question 14

When integrating separate REA diagrams,

A)common resources are placed between the events that affect them.
B)each resource is connected to two agents.
C)resources are duplicated to show the give and get of economic duality relationships.
D)resources are merged if both events in the stockflow relationship are modeled.

Question 15

Which entity is most likely to be part of both the payroll cycle and the revenue cycle?

A)Cash.
B)Customer.
C)Receive Goods.
D)Inventory.

Question 16

Which of the following statements is not true with regards to a correctly drawn enterprise-wide REA diagram?

A)Every event must be linked to at least one resource.
B)Merging two transaction cycles on a common event may affect the minimum cardinalities between the merged event and the other events.
C)Events can only be merged if they share the same resources and events.
D)Creating a set of tables from an REA diagram automatically results in a well-structured relational database.

Question 17

Integrating separate REA diagrams into a single comprehensive enterprise-wide model of the organization requires understanding what the ________ in each separate diagram reveal about the organization's business policies and activities.

A)cardinalities
B)data
C)events
D)transactions

Question 18

Integrating separate REA diagrams developed for individual transaction cycles into a single,comprehensive enterprise-wide data model

A)is possible.
B)requires understanding what the cardinalities in each separate diagram reveal about the organization's business policies and activities.
C)provides a single comprehensive enterprise-wide model of the organization.
D)All of the above are true.

Question 19

Which entity is most likely to be part of both the payroll cycle and the expenditure cycle?

A)Receive Goods.
B)Customer.
C)Disburse Cash.
D)Inventory.

Question 20

Which entity is most likely to be part of both the revenue cycle and the expenditure cycle?

A)Receive Goods.
B)Customer.
C)Receive Cash.
D)Inventory.

Question 21

The primary key for M:N relationship tables

A)is a single attribute.
B)always consists of two attributes.
C)is the primary key of the most important entity linked to that relationship.
D)does not exist. Many-to-many relationship tables only use foreign keys.

Question 22

In an REA diagram,resource entities

A)can be linked to event entities in Business Cycle A and to event entities in Business Cycle B.
B)cannot be linked to event entities in Business Cycle A and to event entities in Business Cycle B.
C)cannot be linked to agent entities.
D)none of the above

Question 23

Two or more primary keys of other database tables that,together,become the unique identifier or primary key of an M:N relationship table are called

A)two attributes keys.
B)concatenated keys.
C)connecteated keys.
D)conjoined keys.

Question 24

When assigning attributes to each table,

A)the database designer must interview users to identify which facts should be included in the database.
B)the database designer must interview management to identify which facts should be included in the database.
C)the database designer must use the REA diagram to help determine in which tables those facts belong.
D)the database designer must do all of the above.

Question 25

REA diagrams for individual business cycles may include some events that also appear in the REA diagrams of another cycle.

Question 26

The primary key for a Purchase-Inventory table that consists of the Purchase Order Number and the Inventory Item Number,is known as a

A)concatenated key.
B)foreign key
C)primary key.
D)dual key.

Question 27

In a complete REA model of any organization,every resource must be connected to at least one ________ that increases that resource and to at least one event that decreases it.

A)resource
B)event
C)agent
D)activity

Question 28

Attributes other than the primary key are

A)included to satisfy transaction processing requirements.
B)included to meet management's information needs.
C)both A and B
D)none of the above

Question 29

Which of the following is not one of the three steps to implementing an REA diagram in a relational database?

A)Assign attributes to appropriate tables.
B)Create a table for each distinct entity in the diagram and for each many-to-many relationship.
C)Link every event to at least one resource.
D)Use foreign keys to implement one-to-one and one-to-many relationships.

Question 30

When integrating multiple REA diagrams into an integrated REA diagram,merging redundant resources

A)always affects minimum cardinalities associated with the merged event.
B)sometimes affects minimum cardinalities associated with the merged event.
C)never affects minimum cardinalities associated with the merged event.
D)none of the above

Question 31

Merging redundant resources will affect cardinalities.

Question 32

Which of the following is false with regards to creating database tables from an REA diagram?

A)A properly designed relational database has a table for each distinct entity in an REA diagram.
B)A properly designed relational database has a table for each many-to-many relationship in an REA diagram.
C)To reduce confusion, table names should not duplicate REA diagram entities' names.
D)Many-to-many relationships will be shown in tables with hyphenated concatenations of the entities' names.

Question 33

What is the first step to implementing an REA diagram in a relational database?

A)Assign attributes to appropriate tables.
B)Create a table for each distinct entity in the diagram and for each many-to-many relationship.
C)Identify cardinalities.
D)Use foreign keys to implement one-to-one and one-to-many relationships.

Question 34

When integrating multiple REA diagrams into an integrated REA diagram,to merge an event that appears in both business cycle REA diagrams,

A)the event that appears in both business cycle REA diagrams may be linked to either an event that is part of one business cycle or to an event that is part of another business cycle.
B)the event that appears in both business cycle REA diagrams may be linked to an event that is part of one business cycle and to an event that is part of another business cycle.
C)One cannot merge an event that appears in both business cycles.
D)none of the above

Question 35

Why might the same REA diagram result in different relationship cardinalities?

A)Different organizations might have different business policies.
B)Different designers might implement an REA diagram differently.
C)Different consultants might draw an REA diagram differently.
D)Errors occur in the REA diagram.

Question 36

Which of the following is not one of the steps in implementing an REA diagram in a relational database?

A)Implement many-to-many relationships with foreign keys.
B)Create tables for entities.
C)Assign attributes to tables and identify primary keys.
D)Implement one-to-many relationships with foreign keys.

Question 37

The type of relationship between two entities is determined by

A)maximum cardinalities only.
B)minimum cardinalities only.
C)minimum and maximum cardinalities.
D)median cardinalities.

Question 38

Which of the following is true with regards to REA diagrams and relational databases?

A)A well-designed relational database is the starting point for creating an REA diagram.
B)A well-designed REA diagram minimizes update, insert or delete anomaly problem when the diagram is implemented into a relational database.
C)REA diagrams and database design are generic across organizations.
D)The design of a relational database is specific to the organization being modeled.

Question 39

The primary key for 1:1 relationship tables

A)is a single attribute.
B)always consists of two attributes.
C)is the primary key of the most important entity linked to that relationship.
D)does not exist. Many-to-many relationship tables only use foreign keys.

Question 40

When using an REA diagram to develop a database,a many-to-many relationship must be

A)broken into two, one-to-one relationships.
B)combined into a single one-to-one relationship.
C)combined into a one-to-many relationship.
D)broken into two, one-to-many relationships.

Question 41

Which of the statements below is false with regards to creating database tables from an REA diagram?

A)M:N relationships must be implemented as separate tables.
B)1:N relationships are implemented with the primary key of the 1 side becoming a foreign key on the N side.
C)1:1 relationships are implemented with the primary key of either entity included as a foreign key in the table representing the other entity.
D)All of the above are true.

Question 42

In a relational database,which of the following attributes would typically be represented by a foreign key in the table that stores data about a Disburse Cash entity?

A)Amount.
B)Date.
C)Vendor number.
D)Product number.

Question 43

In a relational database,which of the following attributes would typically be represented by a foreign key in the table that stores data about a Receive Inventory entity?

A)Purchase order number.
B)Payment terms.
C)Product code.
D)Date.

Question 44

Which of the statements below is false with regards to the tables for M:N relationships?

A)Non-key attributes may be included.
B)Multiple attribute primary keys are used.
C)Single attribute primary keys may be used.
D)Concatenated keys are used.

Question 45

How many tables are needed to implement an REA data model that has five distinct entities,two M:N relationships and three 1:N relationships in a relational database?

A)5
B)7
C)8
D)10

Question 46

How many tables are needed to implement an REA data model that has six distinct entities,three M:N relationships and four 1:N relationships in a relational database?

A)6
B)9
C)11
D)13

Question 47

Which table is most likely to have a concatenated key?

A)Inventory.
B)Sales.
C)Sales-inventory.
D)Accounts receivable.

Question 48

In which of the following cases is the relationship between entities not implemented by foreign keys?

A)

B)

C)

D)

Question 49

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. Which of the following would be an attribute in the table for Display Space Rental?

A)Convention name.
B)Deposit paid.
C)Balance paid.
D)Convention address.

Question 50

In which of the following cases is the number of tables required to represent the relationship equal to three?

A)

B)

C)

D)

Question 51

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. Which of the following would not be an attribute in the Purchases table?

A)Address where purchase was made.
B)Person's name or company name from whom the purchase was made.
C)Date of purchase.
D)Total amount of purchase.

Question 52

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. Which of the following would not be an attribute in the Inventory table?

A)Total amount of purchase.
B)Price paid for inventory.
C)Asking price.
D)Inventory number.

Question 53

How many tables are needed to implement an REA data model that has three distinct entities,two M:N relationships and two 1:N relationships in a relational database?

A)5
B)7
C)8
D)10

Question 54

Which of the following is not part of a "final accuracy check" when creating relational tables from an REA diagram?

A)Every attribute in every table is single-valued (i.e., each table is a flat file).
B)Every event must be linked to at least one resource.
C)Every table must have a primary key.
D)Other non-key attributes in each table must be either a fact about the thing designated by the primary key or foreign keys used to link that table to another table.

Question 55

Implementation of this REA diagram into a relational database would require how many tables?

A)12
B)13
C)8
D)9

Question 56

Concatenated keys are

A)used when combining two or more REA diagrams.
B)foreign keys used to implement 1:N or 1:1 relationships.
C)multiple attribute keys used to implement 1:M relationships.
D)used to implement M:N relationships.

Question 57

Which of the following would be true when implementing this REA diagram into a relational database?

A)The primary key for Employee would be a foreign key for Cash Receipts.
B)The primary key for Cash Receipts would be a foreign key for Cash.
C)The primary key for Parts would be a foreign key for Service Request.
D)The primary key for Sales would be a foreign key for Service Request.

Question 58

Which of the following attributes would typically be included in the table that stores data about the Customer entity in a relational database?

A)Invoice number.
B)Credit limit.
C)Product code.
D)Backorder.

Question 59

In a relational database,which of the following attributes would typically be included in the table that stores data about the Vendor entity?

A)Invoice number.
B)Outstanding balance.
C)Product code.
D)Inventory.

Question 60

How many tables are needed to implement an REA data model that has five distinct entities,five M:N relationships and three 1:N relationships in a relational database?

A)5
B)7
C)8
D)10

Question 61

From the choices below,identify the attribute below that would make the best primary key.

A)On campus mailbox number.
B)GPA.
C)Credit hours.
D)Student ID number.

Question 62

From the choices below,identify the attribute below that would make the best primary key.

A)Product number.
B)Date of first purchase.
C)Postal code.
D)Customer telephone number.

Question 63

From the choices below,identify the attribute below that would make the best primary key.

A)Last name.
B)Date of entry.
C)Airport code.
D)Passport control number.

Question 64

Identify the attribute below that would not make a good primary key.

A)Adjusted gross income.
B)Social security number.
C)A unique number automatically generated by the system.
D)Cell phone number.

Question 65

Describe the three steps to the implementation of an REA diagram in a relational database.

Question 66

Much of the information about an organization's assets that is traditionally recorded in ledgers is stored in ________ tables in an REA-based relational database.

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

Question 67

Which of the following is/are true with regards to using REA diagrams to retrieve information from a database?

A)Although neither journals nor ledgers appear explicitly in an REA diagram, each can be created through appropriate queries.
B)The information normally found in a journal is contained in the tables used to record data about events.
C)Much of the information about an organization's assets that is traditionally recorded in ledgers is stored in resource tables in an REA-based relational database.
D)All of the above

Question 68

Rebus Fashions provides haircuts to men and women.Rebus uses an REA database to record information that is important to the firm.Rebus has a table named "Customer" where it keeps information about its customers.Identify the attribute below that most likely does not belong in the Customer table.

A)Customer hair color.
B)Customer hair style.
C)Customer address.
D)All of the above are appropriate attributes for the Customer table.

Question 69

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 70

Rebus Fashions provides haircuts to men and women.Rebus uses an REA database to record information that is important to the firm.Rebus has an M:N table named "Customer-Sale" where it keeps information about customer sales.Identify the attribute below that most likely does not belong in the Customer-Sale table.

A)Date of sale.
B)Time hair cut was started.
C)Name of customer.
D)All of the above are appropriate attributes for the Customer table.

Question 71

Explain a completeness check.

Question 72

Constructing a well-structured,well-developed REA diagram eliminates which anomaly problem(s)?

A)Update.
B)Insert.
C)Delete.
D)All of the above.

Question 73

Rebus Fashions provides haircuts to men and women.Rebus uses an REA database to record information that is important to the firm.Rebus has a table named "Employee" where it keeps information about its hair stylists.Identify the attribute below that most likely does not belong in the Employee table.

A)Stylist phone number.
B)Stylist hair cut specialties.
C)Number of haircuts provided by a stylist on a given day.
D)All of the above are appropriate attributes for the Employee table.

Question 74

Rebus Fashions provides haircuts to men and women.Rebus charges $10 per haircut,no matter what type of haircut the customer selects.Rebus uses an REA database to record information that is important to the firm.Rebus has an M:N table named "Customer-Sale" where it keeps information about customer sales.Identify the attribute below that most likely does not belong in the Customer-Sale table.

A)Date of sale.
B)Time hair cut was finished.
C)Price of haircut.
D)All of the above are appropriate attributes for the Customer table.

Question 75

Describe the steps that should be taken as a final accuracy check for designing a well-structured relational database.

Question 76

When comparing REA diagrams used to design an AIS with a traditionally designed AIS,

A)traditional AIS information, such as journals and ledgers no longer exist.
B)similar information is present as in a traditional AIS, but stored in a different format.
C)queries are used to input data into the AIS.
D)an REA designed AIS cannot recreate a traditional journal.

Question 77

Identify the attribute below that would not make a good primary key.

A)Postal code.
B)Social security number.
C)A unique number automatically generated by the system.
D)Cell phone number.

Question 78

How many tables are needed to implement an REA data model that has four distinct entities,three M:N relationships and one 1:N relationships in a relational database?

A)5
B)7
C)8
D)10

Question 79

How many tables are needed to implement an REA data model that has three distinct entities,two M:N relationships and two 1:N relationships in a relational database?

A)5
B)7
C)8
D)10

Question 80

Identify the attribute below that would not make a good primary key.

A)Birthdate.
B)Social security number.
C)A unique number automatically generated by the system.
D)Cell phone number.