I am trying to set up employees tables. Right now I have the following tables but i am not sure if this is the correct way. I am wanting to have all the employees first, middle and last names, their email address, the email group that they belong to( may be in more than one group), which section of the company they belong to, and their desk phone number. Please let me know if this is the right way to normalize this data. Thank you. I have worked through some of the links on normalization that i have been given here. The part I am having trouble with is in the tbl_EmailUser table an employee may have 4 or more records because of the Email group they are in. I dont think this is right. That is why i am asking for advice. Thank you for any help. --Walker
I have the following tables so far.
tbl_EmailUser
EmailID AutoNumber
UserFirstName Short Text
UserMiddleInitial Short Text
EmailAddress Short Text
UserPhoneNumber Short Text
EmailGroupID Number
UserSectionID Number
tbl_EmailGroup
EmailGroupID AutoNumber
Emailgroup Short Text
tbl_UserSection
UserSectionID AutoNumber
UserSection Short Text