database notes 10-16

database notes 10-16 - to worry about 2 nd normal form....

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Normalization: 1 st normal form: there is a 2-D table, if someone asks for a 2-D table. It’s truly a relation. No repeating groups or multi-valued attributes. 2 nd normal form: no partial dependencies; if your primary key is simple, you don’t need
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: to worry about 2 nd normal form. Only deals with concatenated primary keys. You want all other attributes fully dependant on the primary key. 3 rd normal form: no dependencies between non-key attributes. No transitive dependencies....
View Full Document

This note was uploaded on 03/27/2008 for the course COMP 244 taught by Professor Jenny during the Spring '08 term at Grove City.

Ask a homework question - tutors are online