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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |