Data Redundancy and Update Anomalies Pearson Education Limited

  • Slides: 34
Download presentation

Data Redundancy and Update Anomalies © Pearson Education Limited 1995, 2005

Data Redundancy and Update Anomalies © Pearson Education Limited 1995, 2005

ตวอยางตารางขอมล Emp_ID Emp_Name 110 112 091 010 Dept Salary Account 15, 000 ����� Account

ตวอยางตารางขอมล Emp_ID Emp_Name 110 112 091 010 Dept Salary Account 15, 000 ����� Account 15, 100 �������� 12, 000 ���� IT ����� IT 11, 000 Employee Course_ NO Course_ Name D-Complete 01 Acc PAC 12/0602002 03 01 SPSS Acc PAC 30/4/2002 12/0602002 02 3 D Studio max 31/03/2002 03 03 SPSS 30/4/2002

ผลลพธทไดจากการทำ Employee Emp_ID Course_ Emp_Name Dept NO 110 01 110 03 112 01 091

ผลลพธทไดจากการทำ Employee Emp_ID Course_ Emp_Name Dept NO 110 01 110 03 112 01 091 02 091 03 Account ��������� Account �������� IT ����� Salary 1 NF ตาราง Course_ Name D-Complete 15, 000 Acc PAC 12/0602002 15, 000 SPSS 30/4/2002 15, 100 Acc PAC 12/0602002 12, 000 3 D Studio max 31/03/2002 12, 000 SPSS 30/4/2002

First Normal Form : 1 NF Emp_Name Emp_ID Dept Employee Salary Course_No Dept Emp_ID

First Normal Form : 1 NF Emp_Name Emp_ID Dept Employee Salary Course_No Dept Emp_ID Course_Name D_Complete ผลลพธทไดจากการทำ Employee 1 NF Salary Emp_Name Course_Name D_Complete

Second Normal Form (2 NF) full functional dependency Emp_ID Course_No D_Complete Course_Name Partial Dependency

Second Normal Form (2 NF) full functional dependency Emp_ID Course_No D_Complete Course_Name Partial Dependency เพราะฉะนนตาราง Employee ไมไดอยในรป 2 NF เนองจากม Partial Dependency ตองทำการแตก Relation เพอลดความซำซอนของขอมล ดงน Employee(Emp_id , Course_No , D_Complete) Course(Course_No, Course_Name)

Second Normal Form (2 NF) Employee Emp_ID Emp_Name 001 010 091 110 Dept Salary

Second Normal Form (2 NF) Employee Emp_ID Emp_Name 001 010 091 110 Dept Salary �����Marketing ������ IT ����� 12, 500 Account ����� 15, 000 11, 000 12, 000 Course_No Course_Name 01 02 03 Acc PAC 3 D Studio max SPSS

Third Normal Form : 3 NF Emp_ID Name Job_Class Chg_Hour Transitive Dependency ตาราง Employee

Third Normal Form : 3 NF Emp_ID Name Job_Class Chg_Hour Transitive Dependency ตาราง Employee ไมไดอยในรป 3 NF เนองจากม Dependency ตองทำการแตก Relation เพอลดความซำซอนของขอมล ดงน Employee(Emp_id , Name, Job_Class) Job(Job_Class, Chg_Hour) Transitive

Third Normal Form : 3 NF Emp_Name Emp_ID Employee Job Salary WORK_ON TRAINED D_Complete

Third Normal Form : 3 NF Emp_Name Emp_ID Employee Job Salary WORK_ON TRAINED D_Complete Job_Class Chg_Hour Course_No Course_Name

Boyce-Codd normal form (BCNF)

Boyce-Codd normal form (BCNF)

Data Redundancy and Update Anomalies Pearson Education LimitedData Redundancy and Update Anomalies Pearson Education Limited
Sys Admin and Redundancy And Redundancy By BrandonSys Admin and Redundancy And Redundancy By Brandon
Redundancy and Alternatives to Redundancy Clare Ferguson HRedundancy and Alternatives to Redundancy Clare Ferguson H
Redundancy and Alternatives to Redundancy Clare Ferguson HRedundancy and Alternatives to Redundancy Clare Ferguson H
Control Logix Redundancy 1 Main Redundancy Features OptimizedControl Logix Redundancy 1 Main Redundancy Features Optimized
Unit IV Noers Redundancy Model Noers Redundancy ModelUnit IV Noers Redundancy Model Noers Redundancy Model
redundancy the need for redundancy EPICS is aredundancy the need for redundancy EPICS is a
LAN Redundancy STP Introduction Network redundancy is aLAN Redundancy STP Introduction Network redundancy is a
Redundancy Principle Chapter 6 What is the RedundancyRedundancy Principle Chapter 6 What is the Redundancy
Controlled Redundancy redundancy 1 Database Design Methodology lControlled Redundancy redundancy 1 Database Design Methodology l
Equipment Anomalies revisited Equipment Anomalies Radio Chest HarnessEquipment Anomalies revisited Equipment Anomalies Radio Chest Harness
Vascular Anomalies A Review Introduction Vascular anomalies VascularVascular Anomalies A Review Introduction Vascular anomalies Vascular
Magnetic Anomalies Magnetic anomalies result in the seaMagnetic Anomalies Magnetic anomalies result in the sea
Prevention of dental anomalies Dental anomalies DFA arePrevention of dental anomalies Dental anomalies DFA are
Equipment Anomalies revisited Equipment Anomalies Radio Chest HarnessEquipment Anomalies revisited Equipment Anomalies Radio Chest Harness
CALCULATING ALBANY AIRPORT MONTHLY MEAN TEMPERATURE ANOMALIES AnomaliesCALCULATING ALBANY AIRPORT MONTHLY MEAN TEMPERATURE ANOMALIES Anomalies
Chapter 34 Data Mining Transparencies Pearson Education LimitedChapter 34 Data Mining Transparencies Pearson Education Limited
Chapter 9 DATA WAREHOUSING Transparencies Pearson Education LimitedChapter 9 DATA WAREHOUSING Transparencies Pearson Education Limited
2014 Pearson Education Inc 1 2014 Pearson Education2014 Pearson Education Inc 1 2014 Pearson Education
2015 Pearson Education Inc 2015 Pearson Education Inc2015 Pearson Education Inc 2015 Pearson Education Inc
Olivier Blanchard Pearson Education 2006 Pearson Education MacroeconomiaOlivier Blanchard Pearson Education 2006 Pearson Education Macroeconomia
Olivier Blanchard Pearson Education 2006 Pearson Education MacroeconomiaOlivier Blanchard Pearson Education 2006 Pearson Education Macroeconomia
2018 Pearson Education Inc 1 2018 Pearson Education2018 Pearson Education Inc 1 2018 Pearson Education
Copyright 2012 Pearson Education Inc 2012 Pearson EducationCopyright 2012 Pearson Education Inc 2012 Pearson Education