A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

3 dimention table



 
 
Thread Tools Display Modes
  #1  
Old March 30th, 2005, 07:27 PM
Anchau Nguyen via AccessMonster.com
external usenet poster
 
Posts: n/a
Default 3 dimention table

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.

--
Message posted via http://www.accessmonster.com
  #2  
Old March 30th, 2005, 07:31 PM
Rick B
external usenet poster
 
Posts: n/a
Default

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



"Anchau Nguyen via AccessMonster.com" wrote in
message news:1a840e3d28754db6ba1373e84db14dae@AccessMonste r.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.

--
Message posted via http://www.accessmonster.com



  #3  
Old March 30th, 2005, 09:14 PM
Pat Hartman
external usenet poster
 
Posts: n/a
Default

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.
"Anchau Nguyen via AccessMonster.com" wrote in
message news:1a840e3d28754db6ba1373e84db14dae@AccessMonste r.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.

--
Message posted via http://www.accessmonster.com



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Design help, please SillySally Using Forms 27 March 6th, 2005 05:11 AM
Update - If statement Dan @BCBS Running & Setting Up Queries 13 December 14th, 2004 07:02 PM
transpose john Using Forms 1 November 24th, 2004 07:16 PM
Automatic filling of fields in table two from table one Jim Kelly Database Design 1 September 27th, 2004 10:16 PM
Name not showing ID is René Setting Up & Running Reports 11 June 29th, 2004 01:40 AM


All times are GMT +1. The time now is 01:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.