Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    Normalization Latest

    Uploaded by

    Azizki Wanie
    The document describes the normalization of a database from 1NF to 3NF. It includes entity relationship diagrams and tables for each normalization form. The tables split the data across multiple tables and remove transitive dependencies and partial dependencies according to the rules for normalization forms 2NF and 3NF.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Normalization Latest

    Uploaded by

    Azizki Wanie
    15 views8 pages
    The document describes the normalization of a database from 1NF to 3NF. It includes entity relationship diagrams and tables for each normalization form. The tables split the data across multiple tables and remove transitive dependencies and partial dependencies according to the rules for normalization forms 2NF and 3NF.

    Original Description:

    Normalization latest

    Original Title

    Normalization latest

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes the normalization of a database from 1NF to 3NF. It includes entity relationship diagrams and tables for each normalization form. The tables split the data across multiple tables and remove transitive dependencies and partial dependencies according to the rules for normalization forms 2NF and 3NF.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    15 views8 pages

    Normalization Latest

    Uploaded by

    Azizki Wanie
    The document describes the normalization of a database from 1NF to 3NF. It includes entity relationship diagrams and tables for each normalization form. The tables split the data across multiple tables and remove transitive dependencies and partial dependencies according to the rules for normalization forms 2NF and 3NF.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 8

    NORMALIZATTON

    DEPENDENCY DIAGRAM

    Customer_ Cust_ Cust_Phone Cus_Car_ Car_ Car_SendIn_ Car_SendOut_ Car_


    ID Name Cust_Add No RegisteredNo Model Date Date Damage

    PD PD

    SPID SP_Model SP_Price SP_Sold_Price SP_Quantity SP_Details

    PD
    TD

    Supplier_ Supplier_Tel_No Supplier_Details Clerk_Name Clerk_Tel_No Clerk_


    SupplierID Name ClerkID Details

    PD PD

    MechanicID Mechanic_ Mechanic_Tel_No Mechanic_ Payment_


    Name Details ReceiptNo Total Date

    PD PD
    1NF ( CustomerID, Cus_ Car_RegisteredNo, SPID, SupplierID, ClerkID, MechanicID, Receipt_No, Cust_Name, Cust_Add, Cust_Phone_No,
    Car_Model, Car_SendIn_Date, Car_SendOut_Date, Car_Damage, SP_Model, SP_Price, SP_Sold_Price, SP_Quantity, SP_Details,
    Supplier_Name, Supplier_Tel_No, Supplier_Details, Clerk_Name, Clerk_Tel_No, Clerk_Details, Mechanic_Name, Mechanic_Tel_No,
    Mechanic_Details, Total, Payment_Date )

    PARTIAL DEPENDENCIES

    (CustomerID  Cust_Name, Cust_Add, Cust_Phone_No)

    (Car_RegisteredNo  Car_Model, Car_SendIn_Date, Car_SendOut_Date, Car_Damage)

    (SPID  SP_Model, SP_Price, SP_Sold_Price, SP_Quantity, SP_Details)

    (SupplierID  Supplier_Name, Supplier_Tel_No, Supplier_Details)

    (ClerkID  Clerk_Name, Clerk_Tel_No, Clerk_Details)

    (MechanicID  Mechanic_Name, Mechanic_Tel_No, Mechanic_Details)

    (Receipt_No Payment_Date)

    TRANSITIVE DEPENDENCY

    (SP_Model SP_Price)
    2NF
    Table : CUSTOMER

    Customer_ID Cust_Name Cust_Add Cust_ Phone_No

    CUSTOMER (CustomerID, Cust_Name, Cust_Add, Cust_Phone_No)

    Table : CAR

    Cus_Car_RegisteredNo Car_Model Car_SendIn_Date Car_SendOut_Date Car_Damage

    CAR (Cus_Car_RegisteredNo, Car_Model, Car_SendIn_Date, Car_SendOut_Date, Car_Damage)

    Table : SPARE PARTS

    SPID SP_Model SP_Price SP_Sold_Price SP_Quantity SP_Details


    TD

    SPAREPARTS (SPID, SP_Model, SP_Price, SP_Sold_Price, SP_Quantity, SP_Details)


    Table : SUPPLIER

    SupplierID Supplier_Name Supplier_Tel_No Supplier_Details

    SUPPLIER (SupplierID, Supplier_Name, Supplier_Tel_No, Supplier_Details)

    Table : CLERK

    ClerkID Clerk_Name Clerk_Tel_No Clerk_Details

    CLERK (ClerkID, Clerk_Name, Clerk_Tel_No, Clerk_Details)

    Table : MECHANIC

    MechanicID Mechanic_Name Mechanic_Tel_No Mechanic_Details

    MECHANIC (MechanicID, Mechanic_Name, Mechanic_Tel_No, Mechanic_Details)


    Table : CUSTOMER PAYMENT

    ReceiptNo Payment_Date

    CUSTOMER PAYMENT (Receipt_No, Payment_Date)

    Table : TOTAL PAYMENT

    Cus_Car_RegisteredNo SPID Total

    TOTAL PAYMENT (Cus_Car_RegisteredNo, SPID, Total)


    3NF

    Table : CUSTOMER

    Customer_ID Cust_Name Cust_Add Cust_PN

    CUSTOMER (CustomerID, Cust_Name, Cust_Add, Cust_Phone_No)

    Table : CAR

    Cus_Car_RegisteredNo Car_Model Car_SendIn_Date Car_SendOut_Date Car_Damage

    CAR (Cus_Car_RegisteredNo, Car_Model, Car_SendIn_Date, Car_SendOut_Date, Car_Damage)

    Table : SPARE PARTS

    SPID SP_Sold_Price SP_Quantity SP_Details

    SPAREPARTS (SPID, SP_Sold_Price, SP_Quantity, SP_Details)

    Table : SUPPLIER
    SupplierID Supplier_Name Supplier_Tel_No Supplier_Details

    SUPPLIER (SupplierID, Supplier_Name, Supplier_Tel_No, Supplier_Details)

    Table : CLERK

    ClerkID Clerk_Name Clerk_Tel_No Clerk_Details

    CLERK (ClerkID, Clerk_Name, Clerk_Tel_No, Clerk_Details)

    Table : MECHANIC

    MechanicID Mechanic_Name Mechanic_Tel_No Mechanic_Details

    MECHANIC (MechanicID, Mechanic_Name, Mechanic_Tel_No, Mechanic_Details)


    Table : CUSTOMER PAYMENT

    ReceiptNo Payment_Date

    CUSTOMER PAYMENT (Receipt_No, Payment_Date)

    Table : TOTAL PAYMENT

    Cus_Car_RegisteredNo SPID Total

    TOTAL PAYMENT (Cus_Car_RegisteredNo, SPID, Total)

    Table : SPARE PARTS PRICE

    SP_Model SP_Price

    SPARE PARTS PRICE (SP_Model, SP_Price)

    You might also like