E02Normalization

E02Normalization - Database Design Normalization Chapter 5...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Database Design: Normalization Chapter 5, Pratt & Adamski
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Functional Dependence An attribute A is functionally dependent  on  attribute(s) B if: given a value b for B there  is one and only one corresponding value a  for A (at a time). b 2 b 3 a 1 b 1
Background image of page 2
Example: functional dependence All sales representatives in a given pay  class have the same commission rate. SalesRepNumber Name PayClass Commission
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Keys Primary Key:  a minimal set of attributes that  form a candidate key Any attribute or collection of attributes that  functionally determine all attributes in a  record is a Candidate Key. Note:  since no two rows in a relational table  can be duplicates, the entire record is  always a candidate key.
Background image of page 4
Primary Key (C) C determines all attributes No subset of the attributes in C is a  candidate key A key consisting of more than one attribute  is called a “composite key.”
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Good Primary Keys Do not change over the life of the  database Are not “intelligent keys” Are not too long Do not consist of too many attributes (3 or  fewer is good)
Background image of page 6
A value in the “child” table that matches with  the related value in the “parent” table. SalesRep(
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/20/2008 for the course IST 331 taught by Professor Sikder during the Spring '08 term at Cleveland State.

Page1 / 25

E02Normalization - Database Design Normalization Chapter 5...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online