Database Help [modified]
-
Hi I am new to database design and I would like your opinions on my database. I am creating a database to hold website member info. In my register page I ask users who wish to become members to supply the following infos. First Name, Last Name, Profession, Address, City, State, Zip, Phone Number, Email, User Name, Password From the info above, I've created a database called Members, a table called Users, and another table called ContactInfo.
Users ContactInfo
_______________ ___________________
|UserID | |Email |
_______________ ___________________
|Email | |Phone |
_______________ ___________________
|FirstName | |Address |
_______________ ___________________
|LastName | |City |
_______________ ___________________
|UserName | |State |
_______________ ___________________
|Password | |Zip |
_______________ ___________________Do you see any problem with the above database? Please point out any problems that you see. Thank you in advance for your help. -- modified at 3:43 Monday 11th June, 2007
-
Hi I am new to database design and I would like your opinions on my database. I am creating a database to hold website member info. In my register page I ask users who wish to become members to supply the following infos. First Name, Last Name, Profession, Address, City, State, Zip, Phone Number, Email, User Name, Password From the info above, I've created a database called Members, a table called Users, and another table called ContactInfo.
Users ContactInfo
_______________ ___________________
|UserID | |Email |
_______________ ___________________
|Email | |Phone |
_______________ ___________________
|FirstName | |Address |
_______________ ___________________
|LastName | |City |
_______________ ___________________
|UserName | |State |
_______________ ___________________
|Password | |Zip |
_______________ ___________________Do you see any problem with the above database? Please point out any problems that you see. Thank you in advance for your help. -- modified at 3:43 Monday 11th June, 2007
The two tables aren't linked to each other. How will you retrieve user's contact info given his/her userID?
-
Hi I am new to database design and I would like your opinions on my database. I am creating a database to hold website member info. In my register page I ask users who wish to become members to supply the following infos. First Name, Last Name, Profession, Address, City, State, Zip, Phone Number, Email, User Name, Password From the info above, I've created a database called Members, a table called Users, and another table called ContactInfo.
Users ContactInfo
_______________ ___________________
|UserID | |Email |
_______________ ___________________
|Email | |Phone |
_______________ ___________________
|FirstName | |Address |
_______________ ___________________
|LastName | |City |
_______________ ___________________
|UserName | |State |
_______________ ___________________
|Password | |Zip |
_______________ ___________________Do you see any problem with the above database? Please point out any problems that you see. Thank you in advance for your help. -- modified at 3:43 Monday 11th June, 2007
Hi 1. Why two tables? 2. Are you storing more than 1 record in ContactInfo table for a particular user? 3. If you are storing more than 1 contact Info, link should be maintained between those two tables. Users table should have one more column i.e., UserID to maintain unique row. This column should be added to ContactInfo Table so that you can retrieve contact details based on UserID. See definitions of Normalization for more information. There are three normal forms in database design. For best example, have a look at Orders and Order Details tables of Northwind database and check the common column between these two table.
Harini
-
Hi 1. Why two tables? 2. Are you storing more than 1 record in ContactInfo table for a particular user? 3. If you are storing more than 1 contact Info, link should be maintained between those two tables. Users table should have one more column i.e., UserID to maintain unique row. This column should be added to ContactInfo Table so that you can retrieve contact details based on UserID. See definitions of Normalization for more information. There are three normal forms in database design. For best example, have a look at Orders and Order Details tables of Northwind database and check the common column between these two table.
Harini
hi, Database is correct use userid for relation more than email id. it is preferable in database.
k.ravi sankar