A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

database relationships



 
 
Thread Tools Display Modes
  #1  
Old March 15th, 2005, 12:13 AM
talktobatchu
external usenet poster
 
Posts: n/a
Default 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

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

vB 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
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


All times are GMT +1. The time now is 02:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.