Normalization
This presentation is the property of its rightful owner.
Sponsored Links
1 / 32

Normalization PowerPoint PPT Presentation


  • 157 Views
  • Uploaded on
  • Presentation posted in: General

Normalization. Normalization. Normalization เป็นวิธีที่ใช้ในการปรับโครงสร้างของตารางเพื่อให้ได้ตารางที่สามารถเก็บข้อมูลได้โดยไม่มีปัญหาใดๆ ตามมาภายหลัง โดยให้อยู่ในรูปแบบที่เรียกว่า Normal Form มีเป้าหมายหลักคือ การลดความซ้ำซ้อนของข้อมูล และรักษาความถูกต้องให้แก่ข้อมูล.

Download Presentation

Normalization

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Normalization

Normalization


Normalization1

Normalization

  • Normalization Normal Form


Normalization2

Normalization

    • Normalization

    • ( )


Data redundancy and update anomalies

Data Redundancy and Update Anomalies

  • Staff relation Branch relation StaffBranch relation


Data redundancy and update anomalies1

Data Redundancy and Update Anomalies


Data redundancy and update anomalies2

Data Redundancy and Update Anomalies

  • StaffBranch (branch) staff

    • (Insertion)

    • (Deletion)

    • (Modification)


Normalization

Normalization

Normalization

1. First Normal Form(1NF)

2. Second Normal Form(2NF)

3. Third Normal Form(3NF)

4. Boyce-Codd Normal Form(BCNF)

5. Fourth Normal Form(4NF)

6. Fifth Normal Form(5NF)


Normalization

  • Normalization 3 (3NF)

  • Normalization 3NF BCNF

  • 4NF 5NF 4NF 5NF


Normalization

First Normal Form : 1NF

  • First Normal Form : 1NF

  • Relation 1NF

  • Attribute Tuple Repeating Group Multi-valued


Employee

Employee


Normalization

1NF

  • 1. repeating group ()

  • 2.


1nf employee

1NF Employee


Normalization

Emp_Name

Salary

Dept

Emp_ID

Course_No

Course_Name

Employee

D_Complete

First Normal Form : 1NF

Salary

Course_No

Dept

Emp_ID

Emp_Name

Course_Name

Employee

D_Complete

1NF


Normalization

Second Normal Form (2NF)

  • 2. Second Normal Form : 2NF

  • Relation 2NF

  • 1. Relation 1NF

  • 2. Attribute Attribute (Fully Functional Dependency) Partial Dependency


Second normal form 2nf

Second Normal Form (2NF)

full functional dependency

Emp_ID

Course_No

D_Complete

Course_Name

Partial Dependency

Employee 2NF Partial Dependency Relation

Employee(Emp_id , Course_No ,D_Complete)

Course(Course_No, Course_Name)


Second normal form 2nf1

Second Normal Form (2NF)

Employee

Course


Normalization

Third Normal Form : 3NF

  • 3. Third Normal Form : 3NF

  • Relation 3NF

  • 1. Relation 2NF

  • 2. Attribute Attribute Transitive Dependency


Third normal form 3nf

Third Normal Form : 3NF

Emp_ID

Name

Job_Class

Chg_Hour

Transitive Dependency

Employee 3NF Transitive Dependency Relation

Employee(Emp_id ,Name, Job_Class)

Job(Job_Class, Chg_Hour)


Third normal form 3nf1

Third Normal Form : 3NF

Emp_Name

Job

Emp_ID

Salary

Employee

WORK_ON

TRAINED

D_Complete

Job

Course

Chg_Hour

Job_Class

Course_No

Course_Name


Dependency diagram

(Dependency diagram)


Normalization3

Normalization

Entity

Partial

Dependency

1NF

2NF

Transitive

Dependency

3NF


Normalization

Boyce/Codd Normal Form : BCNF

4. Boyce/Codd Normal Form : BCNF

Relation BCNF

1. Relation 3NF

2. Attribute Relation Attribute (Composite Key)


Boyce codd normal form bcnf

Boyce-Codd normal form (BCNF)

  • 3NF BCNF

    • Attribute Attribute Primary key (C B)


Normalization

Boyce/Codd Normal Form : BCNF

S# P# Relation SNAME Attribute S#

S#

SNAME

P#

QTY


Normalization

Boyce/Codd Normal Form : BCNF

S#

SNAME

P#

QTY

Relation SUPPLIER3 attribute PK

ORDER2(SNAME, P#, QTY)

SUPPLIER4(SNAME , S#)


Boyce codd normal form bcnf1

Boyce-Codd normal form (BCNF)


Normal form

(Normal Form)

  • relation (Overnormalization)

  • (Denormalization)


Relation overnormalization

relation (Overnormalization)

  • relation 3NF

  • BCNF, 4NF 5NF ()


Normalization

  • relation (Overnormalization)

    • relation relation


Denormalization

(Denormalization)

  • Normalization relation 3NF 2NF


Denormalization1

(Denormalization)

    • relation (Select)


Normalization

Normalization


  • Login