Database Design Question

Hi Gang,

First time post so I hope someone can help me out here.

I have to design a database for a website that I am doing and I'm not sure what the best way to go about it is.

This website is all about registering memebers that have occupations and I have to model this.

So the members have all the normal fields like:

FirstName
Surname
Address
Gender
TelephoneNumber
...
...
etc

and they also have Occupations which have these sorta fields:

Position
YearsExperience
CareerStepDecision
EmploymentBasis (i.e -> Fulltime, parttime, casual)
EmployerName
EmployerAddress
EmployerSuburb
...
...
etc


Now my question is......should I seperate out the Occupation and Members into 2 seperate tables or should I combine them into one table called say tblMembers??

I'd appreciate any help and/or references.


Thankyou in advance.



Ben

 

Depends. Are they going to manually type in occupations/etc, or will they select from a dropdown box? If the latter, use two tables, give the occupations an id, and just have that id value put in the users table for whatever they select; else, put it all in one table, though that's not efficient.