Review Figure 7.7. Which of the following is a correct posting of a foreign key

Question

Review Figure 7.7. Which of the following is a correct posting of a foreign key to implement the model in a relational database?

A. Labor Operations primary key becomes a foreign key in Production Authorization.
B. Products primary key becomes a foreign key in Bill of Material.
C. Product Categories primary key becomes a foreign key in Sunset Partners.
D. Products primary key becomes a foreign key in Product Categories.
E. All of the choices are correct.

FIGURE 7.7 Linked Conversion Process Tables and with Referential Integrity Enforced tblMaterials tbiMaterial Issue Material number Material description Material_price Material quantity on hand Material_notes Matl Issue number Issue date ksued by Prod Auth number Material,number tblMaterial Issue Material Matl issue number Material number Qty issued tblBill of Material BOM number Issue sequence Standard quantity Product,number Material_number Special handling Pro Prod auth,date Partner.number Product,Number Sched_qty.to produce Actual qty produced Scheduled.completion.c Actual, completion, date tblPartnens Partner number Partner,first,name Partner last name Partner hire,date Partner SocSecNo Partner Address Partner Address2 tblProducts tblLabor Operations Product, description Productprice Product unit of sale Product category Product quantity o Product notes Labor Ops Number Prod auth number Labor ops,description tblLabor.Operations Partners Laborops number Partner_number Actual direct labor hours Actual_direct labor wage Product,category.number Product category,description Product category, manager Product, category.notes

Explanation / Answer

Which of the following is a correct posting of a foreign key to implement the model in a relational database?

B. Products primary key becomes a foreign key in Bill of Material.

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.