Question

Joshua has a logical proposal for our new Inventory table and its relationships with the other tables. He has even included a reorder point, so we know when to reorder specific parts :-) Are these calculated fields? What did you say about calculated fields in a table?
Would we also need to account for things like the dog's 4 legs, its tail, ears, tongue and so on? (These parts are not the same as the other
models, as they all resemble humans.)

INVENTORY
ItemNum     Description     ProdNum     ON_HAND     ON_ORDR     REORDRPNT
1234     Voice Box     8844     4     1     5
5678     Casing     8844     8     0     7
9010     Flash Drive     8844     5     0     3
9110     Sound Recorder     8844     4     0     3
                         
For the additional table, inventory, the primary key will be the ItemNum field. It will also have a Foreign Key the ProdNum field, which is the primary key of the Products table.   This table will have a relationship with the Products table as it is linked to the Product models for inventory tracking, and it will also have a relationship with the orders table and rules created to automatically reduce on_hand quantities as the order for ProdNum 8844 is placed.