Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Resources in the REA enterprise ontology are defined as: Anything from a single activity of producing a report to an entire transaction cycle. Things of

  1. Resources in the REA enterprise ontology are defined as:
  1. Anything from a single activity of producing a report to an entire transaction cycle.
  2. Things of value provided or consumed by an enterprises activities and operations.
  3. Individuals, departments, divisions, or organizations that participate in the control and execution of event.
  4. Interconnected business processes
  5. Activities within an enterprise that need to be planned, controlled, executed, and evaluated

  1. What is the primary deliverable expected to be attained using the REA model?
  1. An optimized linear programming solution for the logistical issues of the enterprise.
  2. A blueprint for re-engineering the enterprise workflow.
  3. A set of program code used to connect different modules of a best breed ERP system.
  4. A complete strategic analysis of the enterprises business plan.
  5. An operational enterprise-wide transaction database.

  1. In a REA model, a relationship between two events
  1. Is always a stock-flow relationship
  2. Sometimes reflects the fact that one of the events fulfills the other event
  3. Requires that both events are also related to the same internal agent
  4. Is always a duality relationship
  5. Is always a control relationship

  1. In the REA model, the act of an accounts payable clerk receiving a vendor invoice that summarizes information regarding the transfer of goods or services from the vendor to the enterprise is a(an):
  1. Economic increment event
  2. Instigation event
  3. Economic decrement event
  4. Commitment event
  5. Information event that further describers the economic increment event

  1. In the REA model, the act of shipping clerk sending defective or unwanted goods back to a supplier is a(an):
  1. Economic increment reversal event
  2. Economic decrement event
  3. Economic increment event
  4. Commitment event
  5. Instigation event

  1. The relationship typically fount between sale and cash receipt in the sales/collection process of an enterprise value chain is called a:
  1. Duality relationship
  2. Resultant relationship
  3. Stockflow relationship
  4. Authorization relationship
  5. Responsibility relationship

  1. The rule converting conceptual model relationship with maximum participating cardinalities of many-to-many into relational database table is:
  1. Post the key attribute of either entity into the relation of the other entity
  2. Create a relation that can have no attributes of its own.
  3. Create a separate table identified by a concatenated primary key comprised of the key attributes from both entity tables
  4. Post the key attribute of the table with mandatory participation into the table with optional participation
  5. Create a separate table identified by the key attributes of the entity that has the most instance

  1. If you have two entities that are related with a cardinality pattern of (1, 1) (1, N) how many tables must you include in a correctly designed database to represent this emtity-realtionship cluster?
  1. One
  2. Two
  3. Three
  4. Four
  5. Five

  1. The participation cardinalities of a relationship between an external agent and a noncash economic event (such as a sale) are most often:

(EXTERNAL AGENT --------------- ECONOMIC EVENT)

  1. External agent (0, 1) participation (1, 1) economic event
  2. External agent (0, N) participation (0 ,1) economic event
  3. External agent (1,1) participation (0, N) economic event
  4. External agent (0, N) participation (1, 1) economic event
  5. External agent (0, N) participation (1, N) economic event

  1. The following conceptual representation in ER grammar format

The following scenario:

(CASH RECEIPT >0------------II SALE)

  1. Allow for accounts receivable
  2. Allows for installment payments
  3. Indicates a sale will always be paid in full when a payment for the sale is made
  4. Both A and B above
  5. Both A and C above

  1. Which of the statements listed below in an accurate interpretation of one or more of the participation cardinalities as depicted between the Sale Order and Shipment events in the following conceptual model?

(SHIPMENT >0------------0I SALE ORDER)

  1. No sale order can be taken without a prior shipment to the customer.
  2. No shipment can be made without a valid sale order.
  3. Both A and B above are accurate interpretations of the depicted cardinalities.
  4. A sale order can be fulfilled in multiple shipment events.
  5. Each shipment can be associated with multiple sale order.

  1. Using the corresponding conceptual model for bumkins manufacturing indicates the one best answer from the choices below

The following scenario:

(PRODUCT >I------------II SALE)

  1. Bumpkins manufacturing holds (stocks) product inventory.
  2. Bumpkins builds custom products for each sale.
  3. The correct answer is not mentioned here.
  4. Bumpkins sometimes re-acquires products if previously sold and then sells them again.
  5. Bumpkins sales are for only one product.

  1. A company purchases custom-made (i.e one-of-a-kind) inventory for re-sale its customers. The company often purchases multiple items as a part of the same purchase. Maximum cardinalities for the relationship between purchase and inventory are:
  1. Maximum on purchase = many; maximum on inventory = many
  2. Maximum on purchase = one; maximum on inventory = one
  3. Maximum on purchase = many; maximum on inventory = one
  4. Maximum on purchase = one; maximum on inventory = many
  5. Maximum on purchase = one; maximum on inventory = none

  1. Which of the following is economic event?
  1. Cash
  2. Purchase of materials
  3. Supplier
  4. Purchasing agent
  5. Materials inventory

  1. Which of the following minimum and maximum participation cardinalities represent an entity that has nonmandatory participation in a relationship and can participate in the relationship many times?
  1. (0, N)
  2. (0, 1)
  3. (1, 1)
  4. (1, N)
  5. (1, 2)

  1. Which of the following pairs of entities would typically be associated with each other in stockflow relationship in a REA model?
  1. Vendor and inventory
  2. Purchase and inventory
  3. Inventory and cash
  4. Purchase & cash disbursement
  5. Purchase & purchasing agent

  1. The casual relationship between a give event and a take event is a ______ and ______ is defined as the inflow or outflow of a resource:
  1. Duality relationship; stockflow
  2. Conversion relationship; timing
  3. Stockflow relationship; duality
  4. Value chain relationship; resource flow
  5. Difference relationship; process

  1. Normalization is:
  1. The process of following the guidelines for establishing the differential integrity rule.
  2. The process of following the guidelines for properly designing a relation database that is free from, delete, insert, and update anomalies.
  3. The process of following the guidelines for comforting and REA model into a relational database.
  4. Both A & B
  5. Both B & C

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Visual Basic 6 Databases

Authors: Charles Williams

1st Edition

1861002025, 978-1861002020

More Books

Students also viewed these Databases questions