Justine Fred Bautista Justine Fred Bautista -3 years ago 97
Java Question

Putting data in different columns in database table

Is it possible to put data in different columns in the database table but using the same variable used? For example, for column1 is # of hours worked for day1, while column2 is # of hours worked for day2, etc. Here's my database screenshot

Answer Source

Try to normalize the database instead of having all the columns in one table. You can have one table for all the user information (idnum, first_name,last_name,address) and another table for storing the working hours (idnum, date, timein, timeout). Use time columns as DateTime.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download