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
|
|||
|
|||
database relationships
hello
as suggested by Jeff Boyce I had redesigned by Access database to remove redundancies to make it a normalized one. The tables have all the required fields to store the data and need help in relating them with one another. ctyDistrictRegion(table 1) ----------------------- ctyDistID(county's ID) distNo(District Number of the county) ctyName(name of the county) ctyRegion(region of the county) this table basically stores all the county names and their district numbers along with the region(border or within). diseaseNames(table 2) ------------------- diseaseID(number for identiying the disease) diseaseName(name of the disease) ctyDiseaseStatistics(table 3) -------------------- EntryID(disease information record ID) diseaseID(refers the diseaseNames table) StatisticsYear(year the information is being stored for) ctyDistrictNumber(refers the ctyDistrictRegion table) populationCount(population for the particular county) numberOfCases( cases reported for the disease) caseRate(optional field, calculating the disease rate) The above three tables of the database store information for various diseases for all the counties in our state and for all respective years. Are the above tables enough for storing the information and how best they can be related (or designed) to each other for removing redundancies. Also if I want to store the population data according to the age groups or say, only for teen agers(need in some diseases), what extra table should be related to the ctyDiseaseStatistics table. thanks for any help. talktobatchu. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I move the MDW file? | Damien McBain | General Discussion | 7 | September 28th, 2004 09:54 AM |
Relationships for database | jeff4379 | Database Design | 3 | September 25th, 2004 07:08 AM |
Template Wizard Problem - Database Structure | setoFairfax | General Discussion | 1 | September 17th, 2004 09:26 AM |
Please Help, The database is in an unexpected state; Microsoft Access can't open it. | Gary A. Hollenbeck | New Users | 2 | May 20th, 2004 05:42 PM |