Top DevX Stories
Creating Custom Export Filters for StarOffice with XSLT
WPF Wonders: Using DataTemplates
Crystal Reports Family Offers Options for Developers
Avaya Aura Session Manager video
Avaya Aura Overview video
Search the forums:

Go Back   DevX.com Forums > DevX Developer Forums > Database

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 10-21-2009, 01:06 AM
gravity gravity is offline
Registered User
 
Join Date: Oct 2009
Posts: 1
Data Modelling Problem - Please Assist

Hi,

I am working on an database for statistics collection and I have the following problem.

I need to be able do the following:
1. User Decides Data disaggregation factors (such as gender/location/time etc)
2. Then one can store data according to disaggregation factors, so if the factor is gender, data should be entered for males and females (say if we are studying number of patients treated, at the point of data entry one would enter number of male patients and number of female patient. In the case of location disaggregation factor, user would enter any number of locations (could be towns), and data would be entered/stored accordingly. So instead of male and female data as in the first example, data would be stored for all patients, location wise. To complicate matters a bit further, the disaggregation factors can be combined. This means a user can decide a certain piece of data is to be aggregated by both gender and location, and one should be able to store/query the records accordingly (i.e. store male patients from a certain location). The disaggregation factors could be anything a user decides them to me.

Can you advise how to best model this using E-R?
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

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

BB 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
Problem with Data Adapter Update max caber .NET 4 07-03-2007 02:06 PM
Problem with fetching data madhulatha_b VB Classic 0 12-07-2006 10:33 AM
Data Environment - Cache Results problem BernS VB Classic 0 06-20-2002 10:27 AM
Problem with inserting data into a related field using ADO (Please help) Shravan VB Classic 2 05-02-2002 04:10 PM
Data List Control Problem John VB Classic 0 10-12-2001 06:09 PM


All times are GMT -4. The time now is 11:01 PM.


Sponsored Links



Acceptable Use Policy

internet.comMediabistrojusttechjobs.comGraphics.com

WebMediaBrands Corporate Info


Advertise | Newsletters | Feedback | Submit News

Legal Notices | Licensing | Permissions | Privacy Policy


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.