Say you have been brought in to check the work of a person who developed a database for Marty's Manufacturing. The conceptual model for Marty's Manufacturing includes the following relationship:
The relational database tables, which are implemented in Microsoft Access, include a table for Production Order and a table for Production Run. The primary key of Production Order (PO) is posted into the Production Run table as a foreign key. You are required in your inspection to ensure that each minimum and maximum cardinality in the conceptual model is appropriately reflected in the table design. What should you look for in the table design to determine whether the 1 minimum on Production Run is appropriately reflected in the database tables?

Question

Say you have been brought in to check the work of a person who developed a database for Marty's Manufacturing. The conceptual model for Marty's Manufacturing includes the following relationship:
  The relational database tables, which are implemented in Microsoft Access, include a table for Production Order and a table for Production Run. The primary key of Production Order (PO) is posted into the Production Run table as a foreign key. You are required in your inspection to ensure that each minimum and maximum cardinality in the conceptual model is appropriately reflected in the table design. What should you look for in the table design to determine whether the 1 minimum on Production Run is appropriately reflected in the database tables?

Quizplus · Accepted Answer

The Answer of Say you have been brought in to check the work of a person who developed a database for Marty's Manufacturing. The conceptual model for Marty's Manufacturing includes the following relationship:
  The relational database tables, which are implemented in Microsoft Access, include a table for Production Order and a table for Production Run. The primary key of Production Order (PO) is posted into the Production Run table as a foreign key. You are required in your inspection to ensure that each minimum and maximum cardinality in the conceptual model is appropriately reflected in the table design. What should you look for in the table design to determine whether the 1 minimum on Production Run is appropriately reflected in the database tables?

Say You Have Been Brought in to Check the Work