Question 1

A groups entity is used to depict the following relationship.

Accepted Answer

A groups entity is used to represent a set of entities, and each member of the set is a member of the group. Therefore, the is-a-member-of relationship is the most appropriate choice for this entity.

Question 2

If the actual cost of an inventory item is maintained as an attribute in the Inventory table,which inventory valuation method would an organization have to use?

Accepted Answer

The answer of If the actual cost of an inventory...

Question 3

Identify the entity linked to almost every other entity in an REA diagram for HRM/payroll cycles.

Accepted Answer

The employee is the central entity in the HRM/payroll cycle as they are linked to almost every other entity, such as job titles, payroll, worker IDs, timesheets, and benefits. Without employees, there would be no need for a payroll system or HRM processes.

Question 4

In an REA diagram for the HR/Payroll cycle,the relationship between Employees and Training is typically M:N for all except which of the following reasons?

Accepted Answer

In an HR/Payroll cycle, the relationship between Employees and Training is typically M:N because each employee may attend multiple training events, and each training event may have multiple employees attending. However, one employee may attend the same training event more than once, which would create a one-to-many relationship between Employees and Training.

Question 5

When modeling the issuance of debt,the maximum cardinality from Disburse Cash to Issue Debt is 1 because

Accepted Answer

The answer of When modeling the issuance of debt,the maximum...

Question 6

Identify the entity that stores most of the data typically found in the employee master file.

Accepted Answer

The employee master file typically stores information related to individual employees such as personal details, job title, employment status, salary, benefits, and performance evaluations. While payroll may store some of this information related to compensation and deductions, HR may also have certain records related to hiring and termination. However, the key entity for storing most employee-related data would be the employee data file or master file. Therefore, option B is the correct choice.

Question 7

In addition to modeling Resources,Events,and Agents,identify the two additional concepts an organization will need to incorporate if it wishes to extend the REA to include information about firm policies.

Accepted Answer

Group and Rules are the two additional concepts an organization will need to incorporate if it wishes to extend the REA to include information about firm policies.

Question 8

Type and group entities are similar in that both are abstractions that represent sets of

Accepted Answer

Type and group entities both represent sets of objects, but they do not necessarily include semantics or attributes. Therefore, option A is the best choice.

Question 9

A type entity is used to depict the following relationship.

Accepted Answer

The "type" entity is commonly used to represent a "is-a-kind-of" relationship, where the entity being represented is a specific type or category of something. For example, a "car" entity could be a type of "vehicle" entity, indicating that all cars are a kind of vehicle.

Question 10

A relationship between Skills and Employees is typically modeled as M:N in an REA database model since

Accepted Answer

The M:N relationship is the most appropriate choice because one employee can possess multiple skills, and one skill can be possessed by many employees. This allows for more flexibility in tracking the skills possessed by employees and managing staffing needs accordingly.

Question 11

In which entity would an item's actual cost information most likely be maintained?

Accepted Answer

The answer of In which entity would an item's actual...

Question 12

The relationship between the Disburse Cash and Issue Stock events is modeled as being M:N for all except which of the following reasons?

Accepted Answer

The relationship between Disburse Cash and Issue Stock events is not M:N because for dividend payments, a check must be written to each shareholder individually, making it a one-to-many relationship.

Question 13

The Interview event stores detailed data about each job interview.Since hiring only happens once,but there may have been several interviews,Interview is linked to the Hire Employees event in a(n)________ relationship.

Accepted Answer

The 1:N (one-to-many) relationship is appropriate because each Hire Employees event can have multiple Interview events associated with it, but each Interview event can only be linked to one Hire Employees event.

Question 14

Identify the inventory valuation method below that cannot be calculated in a database created using an REA modeling approach.

Accepted Answer

The REA (Resources, Events, Agents) modeling approach is a database design methodology used for capturing information about resources, events, and agents involved in business transactions. It does not inherently limit the ability to calculate inventory valuation methods such as LIFO (Last In, First Out), FIFO (First In, First Out), or Weighted Average. These inventory valuation methods can be implemented in a database designed using the REA model by appropriately structuring the data and applying the necessary calculations.

Question 15

In which entity would an item's standard cost information most likely be maintained?

Accepted Answer

The standard cost information of an item is maintained in the Inventory entity. This allows for easy access and updating of the cost information for all transactions related to that item, such as purchases and sales. The Order_Inventory entity may contain information related to quantities ordered and received, but not standard costs. The Inventory-Order_Inventory entity does not exist and is not a relevant option.

Question 16

In an REA diagram for the HR/Payroll cycle,the ________ relationship between Skills and Recruiting reflects the fact that one specific advertisement may list several specific skills and,over time,there may be several advertisements for one specific skill.

Accepted Answer

The M:N relationship between Skills and Recruiting reflects the fact that multiple skills can be listed in multiple job advertisements over time, and it is also possible for multiple job advertisements to list the same specific skill. Therefore, the relationship between Skills and Recruiting is best represented by an M:N relationship.

Question 17

The textbook explicitly identifies ________ as situation where a properly designed database can yield tax benefits.

Accepted Answer

The answer of The textbook explicitly identifies ________ as situation...

Question 18

An organization that sells digital products,such as access to view online videos,does not need an inventory table in its database.

Accepted Answer

The answer of An organization that sells digital products,such as...

Question 19

The attributes of which type of entity would provide a way for the system to compare an employee's reimbursement request with the permissible range of the amount of reimbursement permitted?

Accepted Answer

The answer of The attributes of which type of entity...

Question 20

Assume an organization sells digital photographs to customers through its website (the company only sells photographs in digital format,it does not provide a physical copy of any photograph).Identify the attribute below that the organization would not need in its Inventory entity.

Accepted Answer

Reorder point is a quantity at which the organization would need to reorder the product. However, since digital photographs are not physical products that can be depleted, reorder point is not applicable. The organization would still need to have a unique identifier or primary key for each photograph in its inventory, as well as a description and price.

Quiz 19: Special Topics in Rea Modeling