Examples of Normalization

Examples of Normalization - Examples of Normalization...

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

View Full Document Right Arrow Icon
Examples of Normalization Example #1 Product # Name Mfr Mfr_HQ 1001 Walkman Sony Japan 1002 Camera Leica Germany 1003 DVD Sony Japan The functional dependencies here include Product # —> Mfr Mfr —> Mfr_HQ By transitivity we have Product # —> Mfr_HQ This simply means that for any product number, there is an associated unique headquarters. This is a transitive dependency within this table. So, the table is not in 3NF. Solution: Break the table into 2 tables as follows: Product(Product #, Name, Mfr) Company(Mfr, Mfr_HQ)
Background image of page 1

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

View Full DocumentRight Arrow Icon
Example 2 Create normalized tables for above situation Solution: Course (Course# , CourseTitle, Instructor) Student (StudentID, Student Name) GradeSheet (StudentID, Course#, Grade) Class Grade Sheet Course# IDS 410 Section 1 CourseTitle Databases Instructor Ranganathan Student ID Student Name Grade 13456 Jennifer Wu A 23341 Richard Horton B ____ ___________________________ ________ ____ ___________________________ ________
Background image of page 2
Example #3 HEALTH HISTORY REPORT PET ID PET NAME PET TYPE PET AGE OWNER VISIT DATE PROCEDURE 246 ROVER DOG 12 SAM COOK JAN 13/2002 01 - RABIES VACCINATION MAR 27/2002 10 - EXAMINE and TREAT WOUND APR 02/2002 05 - HEART WORM TEST 298 SPOT DOG 2 TERRY KIM JAN 21/2002 08 - TETANUS VACCINATION MAR 10/2002 05 - HEART WORM TEST 341 MORRIS CAT 4 SAM COOK JAN 23/2001 01 - RABIES VACCINATION JAN 13/2002 01 - RABIES VACCINATION 519 TWEEDY BIRD 2 TERRY KIM APR 30/2002 20 - ANNUAL CHECK UP APR 30/2002 12 - EYE WASH Create a set of normalized tables for above situation Solution: UNF/First Cut: Pet [ pet_id, pet_name, pet_type, pet_age, owner, ( visitdate, procedure_no, procedure_name ) ]
Background image of page 3

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

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

This note was uploaded on 11/01/2011 for the course IDS 521 taught by Professor Staff during the Spring '08 term at Ill. Chicago.

Page1 / 7

Examples of Normalization - Examples of Normalization...

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

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