Data Redundancy and Update Anomalies Pearson Education Limited

  • Slides: 48
Download presentation

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

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

Emp_ ID 110 ตวอยางตารางขอมล Employee Emp_Na Dept Salar Course_ me วลาวล ย ขำคม y

Emp_ ID 110 ตวอยางตารางขอมล Employee Emp_Na Dept Salar Course_ me วลาวล ย ขำคม y Accou 15, 00 nt 0 _ NO Name DComplete 01 Acc PAC 12/06020 02 03 SPSS 30/4/200 2 112 อษาวด เจรญก ล Accou 15, 10 nt 0 01 Acc PAC 12/06020 02 091 นพพร บญช IT 02 3 D Studio max 31/03/20 02 03 SPSS 30/4/200 12, 00 0

ผลลพธทไดจากการทำ 1 NF ตาราง Employee Emp_ Cours Emp_Name ID e_ NO Dept Sala ry

ผลลพธทไดจากการทำ 1 NF ตาราง Employee Emp_ Cours Emp_Name ID e_ NO Dept Sala ry Course_ Name DComplet e 110 01 วลาวลย ขำคม Account 15, 0 Acc PAC 12/0602 00 002 110 03 วลาวลย ขำคม Account 15, 0 SPSS 00 112 01 อษาวด เจรญกล Account 15, 1 Acc PAC 12/0602 00 002 091 02 นพพร บญช IT 12, 0 3 D Studio 31/03/20 00 max 02 091 03 นพพร บญช IT 12, 0 SPSS 00 30/4/200 2

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

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

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 ,

Second Normal Form (2 NF) Employee Emp_Na _ID me 001 วนดา แซล 010 กสมา

Second Normal Form (2 NF) Employee Emp_Na _ID me 001 วนดา แซล 010 กสมา รมเยน 091 นพพร บญช 110 วลาวลย Dept Salar y Marketi 12, 50 ng 0 IT 11, 00 0 IT 12, 00 0 Account 15, 000 Course_Na No me 01 Acc PAC 02 3 D Studio max 03 SPSS

Third Normal Form : 3 NF Emp_ID Name Job_Class Chg_Hour Transitive Dependenc ����� Employee

Third Normal Form : 3 NF Emp_ID Name Job_Class Chg_Hour Transitive Dependenc ����� Employee ������� 3 NF ������ Transitive Dependency ������ Relation ����������� Employee(Emp_id , Name, Job_Class)

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 Chg_Hour Job_Class Course_No Course_Name

Boyce-Codd normal form (BCNF)

Boyce-Codd normal form (BCNF)

4. จงทำการ Normalization 4. 1 Items(Po_Number, Item. Num, Part. Num, รเลชนทกำหนดใหตอไปน Description, Price, Qty)

4. จงทำการ Normalization 4. 1 Items(Po_Number, Item. Num, Part. Num, รเลชนทกำหนดใหตอไปน Description, Price, Qty) Po_Number, Item. Num Part. Num, Description, Price, Qty Part. Num Description, Price 4. 2 Store_Item (S_Id, Promotion_Id, Vendor, Style, Price) S_Id, Promotion_Id Vendor, Style, Price S_Id Vendor, Style 4. 3 Staff(D, O, N, T, C, R, Y) D, O N, T, C, R, Y C, R D

4. 4 รหส ผเช ย วชา ญ รหส ความเช ยวชา ญ 21 35 50

4. 4 รหส ผเช ย วชา ญ รหส ความเช ยวชา ญ 21 35 50 ความ เชย ชอ วชา ญ นามส ก ล 113 Syste m Alice Adam s 55 Brown NYC 113 Syste m 179 Databa Tom se Hank 32 Green LA 204 Progra m 179 Databa se Rob er Cody t 40 Yellow Mexico 148 Web รหสแ ชอแผนก ทต ง

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