mardi 23 juin 2015

How to store an element with a lot of fields

I want to design a database system (I use SQLite)and in a table where I keep the history, I store some values of an employee (name,surname, id, etc..) One of the fields are some working positions which currently are 3, but in the future may increased to 4 or 5... Which is is more clever to do?

1) Have a table with all the fields (among them: wp1, wp2, wp3) and later add a column for the wp3, or

2) Store all these working positions to a diferrent table where i will have 2 fields id and wp and store the diferrent wp to multiple records?

Aucun commentaire:

Enregistrer un commentaire