yes, I would need to pull out the revenue out of the product table. revenue = price * quantity_sold. Does that mean I need to create another table for the quantity_sold?

I am getting more confused, as more tables are being created, and I still do not know how do I associate the machine table to all those tables created.