Tech Support Guy banner
Status
Not open for further replies.

Access - Database Set Up Question

878 views 3 replies 4 participants last post by  OBP 
#1 ·
Hi! I'm a web designer - new to databases.

I'm setting up a database for a DJ company, and wanted a second opinion. Is it better to create one table called "Events" (which would necessarily hold a space for only occasionally required fields like BridesName and GroomsName), or to break the table down into a table for Weddings, Parties, Mitzvahs, etc. and either risk some form of redundancy. I'm leaning toward the first option, but wasn't certain, and wanted a second opinion.

Thank you!!! :D

PS - Using Access 2007 (but I don't know that it's relevant to this question) Thank you.
 
#3 ·
Like fried was saying one table will be fine with a "category" field that specifies the type of event. Friedban was talking about 1st, 2nd, 3rd......... etc normal form which is a set of rules that tells you what to think about when setting up a database. I am posting a link to a site which by a quick glance talks about the different rules or normalization which I just talked about. ;)
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top