We are developing a job portal in php and using mysql as database. Total number of fields to be stored in mysql are about 90. So here the challenges we are facing-
1. Shall we store all the fields in one table or distribute in separate tables.
2. How to store multiple entries in one field set like someone may have multiple certifications/qualification/degrees, since the qualification option is kept dynamic and user may enter as many as certifications etc.