A Better Schema for the Transaction Table

The three normal forms are as follows:
  1. Every column of every row must contain only one value
  2. Every non-key column must depend on the entire primary key
  3. No non-key column may depend on another non-key column
Examining the transaction table reveals that it violates the third normal form, because the customer's address, card type, and card number depend on the customer's name.

A better schema might be this:

transact_id title_id number_transacted customer_id
1 101 3 991

customer_id cust_name cust_address card_type card_number
991 Fred Smith 123 Main Street, Anytown, AnyState 00000 Visa 123456789

[ ] [ Course Contents ] [ Home ] [ Curriculum ]
http://www.keller.com/dbweb/4/extra3.html
Updated Wednesday, 31-Oct-2001 14:17:41 CST

Copyright © 2006
Dan Keller Technical Services
4500 19th St., San Francisco
California, USA 94114
tel: 415 / 861-4500