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?

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

From the above figure

The links between

tblLabour_operations and tblLabour_operations_Partners

is a correct posting of a foreign key to implement the model in a relational database.

As primary key in operation table will serve as foreign key in the partners tables.

Thank You

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

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