How many tables in a database?

[Roger Carlson]

14 tables is certainly not too many in any absolute
sense. Many of my databases have far more. I have a
small sample database on my website
called "TrainingRegistration.mdb" which has 12 tables.
The scope of the two is probably similar, so I'd guess
that 14 is reasonable.

However, the correct number of tables is always exactly
the number that you need to solve the problem. Without
seeing the design, I can't say it is correct.

--Roger Carlson
http://www.rogersaccesslibrary.com

>-----Original Message-----
>I have a database for maintaining an inventory of
equipment used by
>students in a professional school. Students are enrolled
for four years,
>for each year there is a specific set of equipment items.
The school
>retains responsibility for ordering the equipment and
stocking the
>students laboratory benches. Each item from the inventory
for each student
>class (Fresh, Soph, etc) is stocked in a particular
location in the
>student bench. The inventory also has cost information. I
have 14 tables
>most of which have information to look-up for data entry
or report
>generation; ie one table has the locations that items
could be stocked,
>another table has student classes, another the items
themselves, yet
>another relates item to year to class. Do I have too many
tables?