Normalization Question

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

After everything I've read on here, I am going back and trying to mormalize
some databases that I have written but not normalized. In one of these, I
have 5 tables that each had "sheet" data and I went in and did make table
queries to make new tables that, hopefully, are more normalized. In the first
table I have District Number and District Name. (District Number is the
primary key in all tables.) In the second table I have District Number,
School, and Project Type #1. Third table I have District Number, School,
Project Type #2. Next 2 tables the same layout. Is this normalized enough or
do I need to do more?
 
I would use 3 tables:

Table: District
Fields: DistrictNumber, DistrictName

Table: DistrictProjects
Fields: DistrictNumber, School, ProjectTypeID

Table: ProjectTypes
Fields: ProjectTypeID, ProjectTypeDescription

This way if you get a new type of project, you don't have to create a new
table, you just add a new record to the project type table.
 
Golfinray said:
After everything I've read on here, I am going back and trying to
mormalize
some databases that I have written but not normalized. In one of these, I
have 5 tables that each had "sheet" data and I went in and did make table
queries to make new tables that, hopefully, are more normalized. In the
first
table I have District Number and District Name. (District Number is the
primary key in all tables.) In the second table I have District Number,
School, and Project Type #1. Third table I have District Number, School,
Project Type #2. Next 2 tables the same layout. Is this normalized enough
or
do I need to do more?
Click to expand...

It doesn't sound like District Number actually is the primary key in all
tables. For instance, if there is more than one school in a district, then
there would be more than one record in the School table with a given
District number.

HTH;

Amy
 
Back
Top