When designing a database, does one need to take into consideration how the data is going to be presented in forms on a website?
For example, when a user fills out a form on a webpage, and one of the form fields is a drop-down box containing all the months in a year, what is the best way to represent this in the database? Would it be ok to just code it like this:
CREATE TABLE student_hours (
...
student_month varchar(15),
...
);
?
Thanks,
Chris
For example, when a user fills out a form on a webpage, and one of the form fields is a drop-down box containing all the months in a year, what is the best way to represent this in the database? Would it be ok to just code it like this:
CREATE TABLE student_hours (
...
student_month varchar(15),
...
);
?
Thanks,
Chris