My two examples are probably similar enough where it doesn't matter but I would like to know how you would do it.
I am creating a table for logging users in and storing user information. Is it best to use 1 table (Option A) or two tables (Option B) with a shared key? I see advantages and disadvantages with both.
Thank you for your reply and a good beginner’s reference to db normalization. My question, and obviously I wasn't specific enough; is all cells are dependent upon the "ID" key. Does it make more sense to have a second table solely for User name, password and login information and another for contact information? I am concerned about consistency and security.
Are you using a DB that does not allow you to grant/revoke column privileges? MySQL DB has a fine grain access control system down to the column level.