SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 02:10 AM
| ||||
| ||||
 Basics of Database Designing - Sample Data Hi Everyone, I am trying to get some hands on database design basics. I have a sample information set below and then the normalized table information Information: FirstName LastName Language Country State ZipCode TimeZone Gender BirthDate Occupation UserID Password SecretQuestion SecretAnswer Altername_EmailID Normalized Tables Derived from the above information set: User_Table: UserID varchar primary key FirstName varchar LastName varchar GenderID short BirthDate date OccupationID short Alternate_EmailID varchar Locale_Table: UserID varchar foreign key on User_Table Langauge varchar Country varchar State varchar ZipCode char TimeZone ???? Authentication_Table UserID varchar foreign key on User_Table Password varchar (Some sort of Encryption maybe required on this column) SecretQuestion varchar SecretAnswer varchar (Some sort of Encrytion maybe required on this column) Gender_Table GenderID short primary key GenderType varchar Occupation_Table OccupationID short primary key OccupationName varchar I know there is lots and lots of room for improvement on this. I am not able to decide as to how should I store the data pertaining to the TimeZone column? Kindly let me know as to what else should I do to further improvise on it. Thanks in advance, dotyet      |
 |
« db2 v8 on windows
|
/usr/lib64 »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 10:35 PM.
