how many Tables i have to create

[sharq1]

Dear All,

I am trying to learn access as fast as I can but ther is a question in my mind I could not reach to a clear answer to it. OI need you help which is,

what is the rule of thump to determine the number of tables i should create, what criteria i should test my project to get the answer. I have different customers from different job natures and i am confused what to how many tables i souuld create for my project.

I appreciate any expert feedback.

Regards

Note: ifr there is a web site that elaborate in this subject i appreciate if you post it.

SHARQ1

 

[KenReay]

Hi

The is no rule of thumb, true applications of simialr type will have similar numebr of tables (eg Inventory applications from different authors will have similar table structures), but this is because they are modelling the same 'thing' ie an Inventory system.

You need to read a good article on Normalisation

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[DrSimon]

Sharq1 there is really no answer to your question, but it's good you've thought of asking it. The answer depends on the information you are trying to model and in order to do that properly you should really learn about relational databases. There must be many books on the subject and even more web sites. A quick surf revealed this one:

http://www.15seconds.com/issue/020522.htm

This covers Codd's Twelve Rules, which is no bad thing as Codd was the father of relational database theory.

I think you have 2 alternatives. If this is a one-off and you need to create a quick small database, get some advice. If not, it really will help if you invesst some time in learning a bit about relational database structure and normalisation.
Good Luck
Simon Rouse