Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Refer to the following integrated diagram, showing part of the purchases and sales processes linked to the conversion process, for Questions 1 through 8. Refer

Refer to the following integrated diagram, showing part of the purchases and sales processes linked to the conversion process, for Questions 1 through 8.

image text in transcribed
  1. Refer to the association marked with the number 1 in the preceding diagram. Which of the following is the best description of the association?
    1. Each supplier participates in a minimum of zero purchases.
    2. Each supplier participates in at least one purchase.
    3. Each supplier participates in a maximum of one purchase.
    4. Supplier is the internal agent in the purchase process.
    5. None of these is a description of the association.
  2. Refer to the association marked with the number 2 in the preceding diagram. Which of the following is the best description of the purpose of the association?
    1. The association links finished goods to the corresponding bill of materials.
    2. The association links purchases to raw materials.
    3. The association identifies the raw materials in a bill of materials.
    4. All of these descriptions are the purposes of the association.
    5. None of these is a description of the purpose of the association.
  3. Refer to the association marked with the number 2 in the preceding diagram. Which of the following is the best description of the association?
    1. Each raw material is related to one bill of material.
    2. Each raw material is related to a maximum of one bill of materials.
    3. A raw material item could be related to multiple bills of materials.
    4. A raw material item could be related to no bill of materials.
    5. None of these is a description of the association.
  4. Refer to the association marked with the number 3 in the preceding diagram. Which of the following is the best description of the association?
    1. Each bill of materials is related to a minimum of zero finished goods.
    2. Each bill of materials is related to a minimum of one finished good.
    3. Each bill of materials is related to a maximum of many finished goods.
    4. Each bill of materials is not necessarily related to a finished good.
    5. None of these is a description of the association.
  5. Refer to the association marked with the number 3 in the preceding diagram. Which of the following is the best way to implement the association in a relational database?
    1. Post the primary key of bill of materials as a foreign key in finished goods.
    2. Post the primary key of finished goods as a foreign key in bill of materials.
    3. Create a linking table between finished goods and bill of materials.
    4. The location of the foreign key is optional.
    5. None of these is the best way to implement the relationship.
  6. Refer to the association marked with the number 4 in the preceding diagram. Which of the following is the best description of the association?
    1. Each finished good is related to one order.
    2. Each finished good is related to a minimum of zero and a maximum of many orders.
    3. Each finished good is related to a minimum of one order.
    4. Each finished good is related to a maximum of one order.
    5. None of these is a description of the association.
  7. Refer to the association marked with the number 5 in the preceding diagram. Which of the following is the best way to implement the association in a relational database?
    1. Post the primary key of Sunset partners as a foreign key in labor operations.
    2. Post the primary key of labor operations as a foreign key in Sunset partners.
    3. Create a linking table between Sunset partners and labor operations.
    4. The location of the foreign key is optional.
    5. None of these is the best way to implement the relationship.
  8. Refer to the association marked with the number 6 in the preceding diagram. Which of the following is the best description of the association?
    1. Each production authorization is related to a minimum of zero material issues.
    2. Each production authorization is related to a minimum of one material issue.
    3. Each production authorization is related to a maximum of one material issue.
    4. Each production authorization is related to a maximum of zero material issues.
    5. None of these is a description of the association.

Thank you

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

Frank Woods Business Accounting Volume 2

Authors: Frank Wood, Ph.D. Sangster, Alan

12th Edition

0273767925, 9780273767923

More Books

Students also viewed these Accounting questions