August 17th, 2013, 04:22 PM
I have a couple of questions. I will greatly appreciate any help I can get. Thanks in advance
1. You are given a table (A, B, C) where A is a low-cardinality attribute, B is a high-cardinality attribute, C is a numerical variable. You're asked to produce cross-tabulation of sum of C by both A and B and show resultant table in Excel spreadsheet. Would you choose to show A as columnar dimension? Why?
2.What key mathematical property of a field is used in deciding if it should belong to an index?
3.What is the general class of dependencies which uniquely identify every record in a table?
August 17th, 2013, 06:29 PM
1. yes, i would... but i'm weird
2. that it not be irrational
3. primary key
August 18th, 2013, 05:39 AM
So much for discouraging the farming out of verbatim homework questions to the forum...
August 18th, 2013, 06:52 AM
i wonder if you actually read my answers, chico
Originally Posted by zxq9