Hi,
I recently (2 days ago) picked up Access/DB design purely because I have other more pressing work to do, and procrastination makes doing anything else a better decision that what you should be doing...
With that out of the way, I've tried to make a database for a "Day Spa" (think saunas, etc...), and have some questions regarding my design, specifically around Normal Forms.
I believe I've hit 1NF.
With regard to 2NF, I'm unsure if the last two columns of the Members table meets that criteria:
The idea behind them being if a member signs up as part of a corporate plan, we hit the "Yes" tick-box, and then select the company from the drop-down list of companies acceptable (lookup to the Companies table)... But, should this be on the Members table, or should I shift both columns to a separate table entirely? One that just has MemberID, CorporatePlan, Company?
In a similar vein, for the Interests table, I wanted new users to be able to select some interest they'd have, like using the Sauna and Pool, while others might just want the Steam Room:
With the table though, is it necessary to have a unique key created by Access (InterestID), or should I just use MemberID and Interest as a composite key? Though, then there'd be nothing else in the table, just the composite keys...
I don't think I have any 3NF issues...? Maybe the Company drop-down in the Members table breaches 3NF? I'm not sure. It doesn't explicitly rely on the CorporatePlan tick-box, except logically.
The definitions elude me ever so slightly!
Thanks