3 dimention table

[Anchau Nguyen via AccessMonster.com]

Would you help me with this problem?
Given: Sex = Female, Male
Rate = 01 ..... 12
Condition = Pass, Fail, Not taken
Question: How many 3 dimention table can you have based on the given above?
Please help.

 

[Rick B]

Not sure what you are asking. In the world of Access, this would be one
table with three fields. Actually you would need more fields to include the
person's name, a primary key, etc.

Then each record you add would have one option for each field listed. So,
you could have a record for...

John
Male
01
Pass


and one for...

Sue
Female
05
Fail


etc.

If you are asking how many unique records you could have where the values do
not repeat, then I am not sure what that has to do with an Access database.

Give us more details.


Rick B

 

[Pat Hartman]

If you are asking how many rows would it take to hold all values in a single
table, the answer is:
2 (sex codes) * 12 (rates) * 3 (conditions) = 72
If you are thinking about using a single lookup table to replace the three
in your question, think again. That would be a really poor idea. Storing
multiple attributes in a single field is a violation of first normal form
but that's just words. You simply have no idea how annoying this structure
will be to work with.
Just the table maintenance would be a nightmare. If you added a new rate,
that would require adding 5 new rows to the table. If you added a new
condition code, that would require adding 24 new rows to the table. If you
added a new sex code (many systems use a third state to represent
"unknown"), that would require adding 36 new rows to the table. There would
be no declarative RI available to ensure that if you added a new value, you
added the correct number of instances of that value to match with the other
attributes.