Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Normalization in Access database tables 1

Status
Not open for further replies.
chark

chark

Instructor
Oct 13, 2000
2
CA
I have been trying to find the correct way of normalizing tables in Access. From what I understand, it goes from the 1st normal form, to 2nd, then 3rd. Usually, that's as far as it goes, but sometimes to the 5th and 6th. Then, there's also the Cobb 3rd.This all makes sense to me. I am supposed to teach a class in this starting next week, and I just got the textbook. It says something entirely different. It says 2nd normal form is only for tables with a multiple-field primary key. 3rd normal form is only for tables with a single-field key. 4th normal form can go from 1st to 4th, where there are no independent one-to-many relationships between primary key and non-key fields. Can someone clear this up for me please?

Chark [sig][/sig]
 
Sort by date Sort by votes
Chark,

I just finished teaching an intermediate class in Access in which I covered database normalization. I used Litwin, Get, and Gilbert's Access 97 Developer's Handbook. Look at Chapter 4. It is a pretty clear explanation.

As an aside, after explaining the concepts of normalization, I had my students create a database for a college registrar (info on classes and schedules). I had the asssignment at their desks when they sat down for the second session. After giving them about 15 minutes to work on it, we brainstormed the tables necessary, their primary keys and the most important fields. It really seemed to reinforce the concepts; since everyone in the class had, at some point, registered for some kind of class.

Hope that helps,
[sig]<p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br> [/sig]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Field size limit Access 365
Replies
5
Views
4K
TrekBiker
TrekBiker
JayRo71
  • Locked
  • Question
Importing only unique records from excel tables 1
Replies
10
Views
939
SkipVought
S
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
706
SkipVought
S
Anthony343242
  • Locked
  • Question
MS ACCESS UNION ALL with Attachment data type 1
2
Replies
29
Views
7K
Anthony343242
Anthony343242
v5652
  • Locked
  • Question
Trouble opening database Make sure the drive is available
Replies
2
Views
641
v5652
v5652

Part and Inventory Search

Sponsor

Back
Top