Web design course
The free_value field itself must be defined with a generic field type like VARCHAR whose size must be wide enough to accommodate all values for all possible corresponding free_name values. It prevents easy validation (for a weight, we need a numeric value). Coding the SQL queries on these free fields becomes more complex i.e. SELECT internal_number from car_free_field where free_name = ‘weight’ and free_value > 2000. Naming Recommendations Here we touch a subject that can become sensitive. Establishing a naming convention is not easily done, because it can interfere with the psychology of the designers. Designer’s Creativity Programmers and designers usually think of themselves as imaginative, creative people; UI design and data model are the areas in which they want to express those qualities. Since naming is writing, they want to put a personal stamp to the column and table names. This is why working as a team for data structure design necessitates a good dose of humility and achieves good results only if everyone is a good team player. Also, when looking at the work of others in this area, there is a great temptation to improve the data elements names. Some discipline in the standardization has to be applied and all the team members have to collaborate. Abbreviations Probably because older database systems had severe restrictions about the representation of variables and data elements in general, the practice of abbreviating has been taught for many years and is followed by many data structure designers and programmers. I used programming languages that accepted only two characters for variable names we had to extensively comment the correspondence between those cropped variables and their meaning. Nowadays, I see no valid reasons for systematically abbreviating all column and table names; after all, who will understand the meaning of your T1 table or your B7 field?
Note: In case you are looking for affordable webhost to host and run your web application check Vision cheap hosting services