Hello, I'm trying to create a simple database to track our Daily Production Summary. I've never setup a database before some I'm looking for some advice on how to structure the Database tables. I'm basically trying to translate the following table into a database:
Date 4/7/2016 Time Name Lot Good lbs Scrap lbs Comment 12-1 Product A Lot 1 10,000 20 Startup Line 1-2 Clean 2-3 Product B Lot 2 15,000 50 Startup Line . . 23-24 50,000 200
I was thinking of having a Production Table with the key being the Date then having all of the fields in the table above listed in the Production Table. The issue with this is the Production Table would have an absurd number of fields. In the case above, there would have to be a Name, Lot, Good lbs, Scrap lbs and Comment field for each hour (24x5=120). It doesn't seem like good practice to have a single table hold all data like this.
Could someone give me advice on how to structure this or point me in the right direction/towards some literature?
Thanks,