Theory Of Database Systems (Assignments)

Assignment: Create a Database that will determine an ODD number of Inventory. Use the tblingredients table.
























SELECT ([inventory] MOD 2) AS ODD, *
FROM tblingredients;

/*through the use of this query which can determine the ODD number inventory
by means of the MOD function built in Microsoft Access*/









SELECT ingredientid, name, unit, unitprice, foodgroup, inventory, vendorid
FROM qrymod1
WHERE odd = 1;

/*This gives us the result of the specified ODD numbered inventory at TBLingredients*/