Consider the database tables in Exhibit 11-15. Describe the necessary procedures

Question

Consider the database tables in Exhibit 11-15. Describe the necessary procedures to construct one or more queries to determine what quantity (and unit of measure) of each ingredient Lucy requisitioned.

EXHIBIT 11-15 Relational Database Tables Encompassing Ingredient Requisition Event IngredientRequisition RequisitionDate Supervisor BakingorderiD RequisitionID 7 14/2010 4:3S:00 PM PO1 1002 1003 7/14/2010 435.30 FM Baking Supervisor SupervisorID supervisarName SupervisorPhone 1-1234 S1 Lucy 14321 Rick ParticipationInventoryClerklngredientRequisition nventoryclerkID IngredientRequisitionID K1 1002 1003 KC1 1002 IC2 1003 Inventory Clerk InventorycierkID ClerkName Cler Phone K1 t-5678 1-876S

Explanation / Answer

SELECT ReservationIngredientRequisitionIngredients.IngredientID, ReservationIngredientRequisitionIngredients.QuantityReserved, ReservationIngredientRequisitionIngredients.UnitofMeasure
FROM ReservationIngredientRequisitionIngredients
where IngredientRequisitionID IN (select RequisitionID FROM IngredientRequisition INNER JOIN BakingSupervisior
ON IngredientRequisition.SupervisiorID=BakingSupervisior.SupervisiorID where BakingSupervisior.SupervisiorName='Lucy' );

First you need to find SupervisiorID(S1) of Lucy that you can find it in BakingSupervisior .then find RequisitionID corresponding to SupervisiorID in IngredientRequisition. Now you have RequisitionID of LUCY ,you can find ingredient information in ReservationIngredientRequisitionIngredients that corresponds to RequisitionID =1003

  

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---