Which is faster/better/why?
Suppose I was creating an hr site...
I could have all the application, applicant response, and ui display info, validation and more in two tables using:
//table to store the ui fields, css layout, field default values, descriptors...
fieldid,fieldName,class,value,validation,page
// this stores the applicant response to each individual field.
applicantid,fieldid, responseValue
_____________________________________________________________
But most examples for this I see are highly relational with many tables....
//application:
applicationid,lastname,firstname,email,
//respondent:
respondentid, applicationid, lastname, firstname
//state_province
stateprovinceid stat_province_name
//country
countryid, country_name
//etc
etcid,
//and on and on...
_______________________________________