Normalization Question

[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?

 

[Chris]

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.

 

[Amy Blankenship]

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?

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