Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

chark (Instructor) (OP)
17 Oct 00 22:42
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
Helpful Member!  kathryn (Programmer)
19 Oct 00 9:43
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,

Kathryn


Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close