Answered step by step
Verified Expert Solution
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.
- Refer to the association marked with the number 1 in the preceding diagram. Which of the following is the best description of the association?
- Each supplier participates in a minimum of zero purchases.
- Each supplier participates in at least one purchase.
- Each supplier participates in a maximum of one purchase.
- Supplier is the internal agent in the purchase process.
- None of these is a description of the association.
- 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?
- The association links finished goods to the corresponding bill of materials.
- The association links purchases to raw materials.
- The association identifies the raw materials in a bill of materials.
- All of these descriptions are the purposes of the association.
- None of these is a description of the purpose of the association.
- Refer to the association marked with the number 2 in the preceding diagram. Which of the following is the best description of the association?
- Each raw material is related to one bill of material.
- Each raw material is related to a maximum of one bill of materials.
- A raw material item could be related to multiple bills of materials.
- A raw material item could be related to no bill of materials.
- None of these is a description of the association.
- Refer to the association marked with the number 3 in the preceding diagram. Which of the following is the best description of the association?
- Each bill of materials is related to a minimum of zero finished goods.
- Each bill of materials is related to a minimum of one finished good.
- Each bill of materials is related to a maximum of many finished goods.
- Each bill of materials is not necessarily related to a finished good.
- None of these is a description of the association.
- 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?
- Post the primary key of bill of materials as a foreign key in finished goods.
- Post the primary key of finished goods as a foreign key in bill of materials.
- Create a linking table between finished goods and bill of materials.
- The location of the foreign key is optional.
- None of these is the best way to implement the relationship.
- Refer to the association marked with the number 4 in the preceding diagram. Which of the following is the best description of the association?
- Each finished good is related to one order.
- Each finished good is related to a minimum of zero and a maximum of many orders.
- Each finished good is related to a minimum of one order.
- Each finished good is related to a maximum of one order.
- None of these is a description of the association.
- 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?
- Post the primary key of Sunset partners as a foreign key in labor operations.
- Post the primary key of labor operations as a foreign key in Sunset partners.
- Create a linking table between Sunset partners and labor operations.
- The location of the foreign key is optional.
- None of these is the best way to implement the relationship.
- Refer to the association marked with the number 6 in the preceding diagram. Which of the following is the best description of the association?
- Each production authorization is related to a minimum of zero material issues.
- Each production authorization is related to a minimum of one material issue.
- Each production authorization is related to a maximum of one material issue.
- Each production authorization is related to a maximum of zero material issues.
- None of these is a description of the association.
Thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started