Single or Multiple Tables

[infdarsas]

Hi,

Currently I have a database that contains four tables. One table contains item question, answers, key, keyword. Another contains author, level 1 classification, level 2 classification, item type. The 3rd contains case text and case title. Finally, the 4th contains graphic title and graphic.

I was wondering if it is better to keep the tables separate as they are right now or combine them into one single table. The average number of items users will add will be about 1,000, if that makes a difference.


Thanks

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[infdarsas]

Do you think I will experience performance issues in my case? I definitely do not have more than 255 columns or anything of such. I also do not have any security issues in which I need to split tables. My current users actually prefer that everything was in one table because they say that it easier to edit if they want to use database view. What are your thoughts?

 

[PHV]

NEVER let an user edit the data directly in table view.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[infdarsas]

What is the problem with doing that? Could they mess something up? Or is it for security reasons?

 

[infdarsas]

And also about splitting the tables, would you do it in my case?

Thanks

 

[PHV]

What are the relationships between this tables ?
I'm not sure they're normalized.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[infdarsas]

They are at a one-to-one relationship through an autonumber field.

 

[pbrodsky]

What does a record (i.e. the data for ONE particular autonumber) represent?