Displaying 2 results from an estimated 2 matches for "surveyresult".
2006 Jun 30
0
Three ActiveRecord features we want at work - any comments/suggestions?
...he problem,
but the one I like best is proposed in the PDF by Darwen, referenced
above. Basically instead of using a flag (ie NULL) in each table to
indicate a missing value, you use a separate table to record why the
information is not available.
For example consider the following table:
SurveyResult: { id, name, address, age, sex, survey_date,
feedback_comments, follow_up_comments }
assuming the following business rules:
A survey result must contain name, address, feedback_comments and
survey_date
A survey result must have name and address deleted two years after
survey_date (to comply...
2003 Feb 17
1
R environment advice?
...ould like to set up a "base"
environment for our project, basically some scripts that connect to a
database, load several database tables into matrices in R, strip the
columns out of those matrices and do some minor tabluation...for
instance:
channel <- odbcConnect(yada, yada, yada)
surveyresults <- (channel, select * from sometable)
multiresults <- (channel, select * from othertable)
multiresults.columnname <- multiresults[,1] # or column 2 or 3 or 4 or
so on...
multiresults.columname.table <- table(multiresults.columnname)
etcetera, etcetera.
I would like to create a s...