Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 21 views

    Normalization For Online Examination Database

    Uploaded by

    Ravi Tej
    The document discusses database normalization and describes the process of normalizing a database into first, second, and third normal forms. It provides examples of student data in an unnormalized format and how it is normalized through each form. The goal of normalization is to organize the database without redundant data and with logical data dependencies by separating attributes into individual tables.

    Copyright:

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

    Normalization For Online Examination Database

    Uploaded by

    Ravi Tej
    21 views48 pages
    The document discusses database normalization and describes the process of normalizing a database into first, second, and third normal forms. It provides examples of student data in an unnormalized format and how it is normalized through each form. The goal of normalization is to organize the database without redundant data and with logical data dependencies by separating attributes into individual tables.

    Original Description:

    gfjng

    Original Title

    NEW DBMS

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses database normalization and describes the process of normalizing a database into first, second, and third normal forms. It provides examples of student data in an unnormalized format and how it is normalized through each form. The goal of normalization is to organize the database without redundant data and with logical data dependencies by separating attributes into individual tables.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    21 views48 pages

    Normalization For Online Examination Database

    Uploaded by

    Ravi Tej
    The document discusses database normalization and describes the process of normalizing a database into first, second, and third normal forms. It provides examples of student data in an unnormalized format and how it is normalized through each form. The goal of normalization is to organize the database without redundant data and with logical data dependencies by separating attributes into individual tables.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 48

    NORMALIZATION FOR

    ONLINE EXAMINATION DA
    Manish Das Mohapatra(IPG_2014054)
    Ravi Chandra(IPG_2014027)
    Kiran Karanam(IPG_2014043)

    Normalization is the process of reorganizing data


    (1) There is no redundancy of data (all data is st
    (2) data dependencies are logical (all related dat
    Normalization is important for many reasons, bu
    performance.

    Name

    DateOfBirth

    Gender

    Prasad
    Emma
    Surya
    Prathyusha
    Suman
    Prabhu
    Sunitha
    Pavan

    11/5/1998
    6/2/1994
    12/19/1998
    8/1/1995
    12/25/1999
    1/4/1993
    6/24/1994
    10/18/1999

    M
    F
    M
    F
    M
    M
    F
    M

    A database is in first normal form if it satisfies the f


    1. Contains only atomic values.
    2. There are no repeating groups.
    An atomic value is a value that cannot be divided.
    Primary Key is introduced so that every row has a u

    Register_id

    Name

    DateOfBirth

    201611
    201611
    201722
    201223
    201445

    Prasad
    Prasad
    Emma
    Surya
    Prathyusha

    11/5/1998
    11/5/1998
    6/2/1994
    12/19/1998
    8/1/1995

    201345
    201345
    201003
    201123
    201135

    Suman
    Suman
    Prabhu
    Sunitha
    Pavan

    12/25/1999
    12/25/1999
    1/4/1993
    6/24/1994
    10/18/1999

    A database is in second normal form if it satisfies t


    1. It is in first normal form
    2. All non-key attributes are fully functional depen
    In this form,Examination name and its entities are
    functional dependency on the primary key i.e. Use

    Register_id

    Name

    DateOfBirth

    201611
    201611
    201722
    201223
    201445
    201345
    201345
    201003
    201123
    201135

    Prasad
    Prasad
    Emma
    Surya
    Prathyusha
    Suman
    Suman
    Prabhu
    Sunitha
    Pavan

    11/5/1998
    11/5/1998
    6/2/1994
    12/19/1998
    8/1/1995
    12/25/1999
    12/25/1999
    1/4/1993
    6/24/1994
    10/18/1999

    Examination Name

    Date

    Result date

    JEE MAINS
    JEE ADV
    CAT
    JEE MAINS
    GATE
    JEE MAINS
    JEE ADV
    GATE
    CAT
    MAINS

    5/19/2016
    25-06-2016
    11/27/2016
    5/19/2016
    2/4/2017
    5/19/2016
    25-06-2016
    2/4/2017
    11/27/2016
    5/19/2016

    6/14/2016
    8/1/2016
    2/14/2017
    6/14/2016
    5/19/2017
    6/14/2016
    8/1/2016
    5/19/2017
    2/14/2017
    6/14/2016

    Register_id

    Examination Name

    201611
    201611
    201722
    201223
    201445
    201345
    201345
    201003
    201123

    JEE MAINS
    JEE ADV
    CAT
    JEE MAINS
    GATE
    JEE MAINS
    JEE ADV
    GATE
    CAT

    201135

    MAINS

    A database is in third normal form if it satisfies the


    1. It is in second normal form
    2. There is no transitive functional dependency
    To remove the redundancy of same phone numbe
    entity from the table and make it a seperate relat

    Register_id

    Name

    DateOfBirth

    201611

    Prasad

    11/5/1998

    201611
    201722
    201223
    201445
    201345
    201345
    201003
    201123
    201135

    Prasad
    Emma
    Surya
    Prathyusha
    Suman
    Suman
    Prabhu
    Sunitha
    Pavan

    11/5/1998
    6/2/1994
    12/19/1998
    8/1/1995
    12/25/1999
    12/25/1999
    1/4/1993
    6/24/1994
    10/18/1999

    Examination Name

    Date

    Result date

    JEE MAINS
    JEE ADV
    CAT
    JEE MAINS
    GATE
    JEE MAINS
    JEE ADV
    GATE
    CAT
    MAINS

    5/19/2016
    25-06-2016
    11/27/2016
    5/19/2016
    2/4/2017
    5/19/2016
    25-06-2016
    2/4/2017
    11/27/2016
    5/19/2016

    6/14/2016
    8/1/2016
    2/14/2017
    6/14/2016
    5/19/2017
    6/14/2016
    8/1/2016
    5/19/2017
    2/14/2017
    6/14/2016

    Register_id

    Examination Name

    201611
    201611
    201722
    201223
    201445

    JEE MAINS
    JEE ADV
    CAT
    JEE MAINS
    GATE

    201345
    201345
    201003
    201123
    201135

    JEE MAINS
    JEE ADV
    GATE
    CAT
    MAINS

    Register_id

    Marks

    Category rank

    201611
    201611
    201722
    201223
    201445
    201345
    201345
    201003
    201123
    201135

    260
    200
    221
    48
    75
    112
    , 73
    46
    112
    17

    601
    985
    2986
    11733
    265
    983
    670
    787
    1270
    559031

    FOR
    ION DATABASE

    By

    054)

    anizing data in a database so that it meets two basic requirem


    all data is stored in only one place)
    related data items are stored together).
    reasons, but chiefly because it allows databases to take up as

    UNNORMALISED

    Age

    Address

    18
    22
    18
    21
    17
    23
    22
    17

    NALLAKUNTA HYDERABAD
    TEXAS USA','USA
    KURNOOL TELANGANA','INDIA
    PUNE MAHARASTRA','INDIA
    BHUVANESHWAR ORISSA','INDIA
    MEHADIPATNAM HYDERABAD','INDIA
    NEW DELHI','INDIA
    PANAJI GOA','INDIA

    Normal Form 1

    atisfies the following conditions:

    be divided.
    row has a unique identity.

    Gender

    Age

    M
    M
    F
    M
    F

    18
    18
    22
    18
    21

    M
    M
    M
    F
    M

    17
    17
    23
    22
    17

    Normal Form 2

    it satisfies the following conditions:

    onal dependent on the primary key


    entities are seperated from the main table because they were
    key i.e. User ID.

    Gender

    Age

    M
    M
    F
    M
    F
    M
    M
    M
    F
    M

    18
    18
    22
    18
    21
    17
    17
    23
    22
    17

    Examination_Duration

    Examination_id

    3 hrs
    3 hrs
    2hrs
    2hrs
    3hrs
    3hrs
    3hrs
    2hrs
    2hrs
    3hrs

    INT01
    ,INT02
    ENGG01
    INT01
    ENGG02
    INT01
    ,INT02
    ENGG02
    ENGG01
    INT01

    Normal Form 3

    satisfies the following conditions:

    endency
    one numbers carried by a particular entity we seperate the ph
    perate relational table.

    Gender

    Age

    18

    M
    F
    M
    F
    M
    M
    M
    F
    M

    18
    22
    18
    21
    17
    17
    23
    22
    17

    Examination_Duration

    Examination_id

    3 hrs
    3 hrs
    2hrs
    2hrs
    3hrs
    3hrs
    3hrs
    2hrs
    2hrs
    3hrs

    INT01
    ,INT02
    ENGG01
    INT01
    ENGG02
    INT01
    ,INT02
    ENGG02
    ENGG01
    INT01

    Ranking

    VERDICT

    765
    260
    3335
    470335
    910
    70333,
    24345
    2435
    70889
    666480

    P
    P
    P
    F
    P
    P
    P
    P
    P
    F

    By

    S
    D

    t meets two basic requirements:

    ther).
    ws databases to take up as little disk space as possible, result

    MALISED

    Phone Number

    Category

    99372081572
    94796632547
    84569871234
    89632587441
    87896541236
    73695462546
    89623658975
    89025463215

    OC
    OC
    ST
    OBC
    SC
    OBC
    SC
    OC

    Address

    Phone Number

    NALLAKUNTA HYDERABAD
    NALLAKUNTA HYDERABAD
    TEXAS USA','USA
    KURNOOL TELANGANA','INDIA
    PUNE MAHARASTRA','INDIA

    99372081572
    99372081572
    94796632547
    84569871234
    89632587441

    orm 1

    BHUVANESHWAR ORISSA','INDIA
    BHUVANESHWAR ORISSA','INDIA
    MEHADIPATNAM HYDERABAD','INDIA
    NEW DELHI','INDIA
    PANAJI GOA','INDIA

    87896541236
    87896541236
    73695462546
    89623658975
    89025463215

    Form 2

    y
    in table because they were not having

    Address

    Phone Number

    NALLAKUNTA HYDERABAD
    NALLAKUNTA HYDERABAD
    TEXAS USA','USA
    KURNOOL TELANGANA','INDIA
    PUNE MAHARASTRA','INDIA
    BHUVANESHWAR ORISSA','INDIA
    BHUVANESHWAR ORISSA','INDIA
    MEHADIPATNAM HYDERABAD','INDIA
    NEW DELHI','INDIA
    PANAJI GOA','INDIA

    99372081572
    99372081572
    94796632547
    84569871234
    89632587441
    87896541236
    87896541236
    73695462546
    89623658975
    89025463215

    Form 3

    r entity we seperate the phone numbers

    Address

    Phone Number

    NALLAKUNTA HYDERABAD

    99372081572

    NALLAKUNTA HYDERABAD
    TEXAS USA','USA
    KURNOOL TELANGANA','INDIA
    PUNE MAHARASTRA','INDIA
    BHUVANESHWAR ORISSA','INDIA
    BHUVANESHWAR ORISSA','INDIA
    MEHADIPATNAM HYDERABAD','INDIA
    NEW DELHI','INDIA
    PANAJI GOA','INDIA

    99372081572
    94796632547
    84569871234
    89632587441
    87896541236
    87896541236
    73695462546
    89623658975
    89025463215

    Submitted To
    Dr.Vinay Singh

    as possible, resulting in increased

    Password

    Examination Name

    P1R2A3S4A5D6
    EMMA1289
    IAMSURYA33
    PRATHYUROCKS
    IAMASUPERMAN
    DONTMESSWITHME
    SUNITHABLOG1453
    PAVANSCOOBY48

    JEE MAINS & JEE ADV


    CAT
    JEE MAINS
    GATE
    JEE MAINS & JEE ADV
    GATE
    CAT
    MAINS

    Category

    Password

    OC
    OC
    OC
    ST
    OBC

    P1R2A3S4A5D6
    P1R2A3S4A5D6
    EMMA1289
    IAMSURYA33
    PRATHYUROCKS

    SC
    SC
    OBC
    SC
    OC

    IAMASUPERMAN
    IAMASUPERMAN
    DONTMESSWITHME
    SUNITHABLOG1453
    PAVANSCOOBY48

    Category

    Password

    OC
    OC
    OC
    ST
    OBC
    SC
    SC
    OBC
    SC
    OC

    P1R2A3S4A5D6
    P1R2A3S4A5D6
    EMMA1289
    IAMSURYA33
    PRATHYUROCKS
    IAMASUPERMAN
    IAMASUPERMAN
    DONTMESSWITHME
    SUNITHABLOG1453
    PAVANSCOOBY48

    Category

    Password

    OC

    P1R2A3S4A5D6

    OC
    OC
    ST
    OBC
    SC
    SC
    OBC
    SC
    OC

    P1R2A3S4A5D6
    EMMA1289
    IAMSURYA33
    PRATHYUROCKS
    IAMASUPERMAN
    IAMASUPERMAN
    DONTMESSWITHME
    SUNITHABLOG1453
    PAVANSCOOBY48

    To
    ngh

    Date

    Result date

    19-05-2016, 25-06-2016
    11/27/2016
    5/19/2016
    2/4/2017
    19-05-2016, 25-06-2016
    2/4/2017
    11/27/2016
    5/19/2016

    14-06-2016,2016-08-01
    2/14/2017
    6/14/2016
    5/19/2017
    14-06-2016,2016-08-01
    5/19/2017
    2/14/2017
    6/14/2016

    Examination Name

    Date

    JEE MAINS
    JEE ADV
    CAT
    JEE MAINS
    GATE

    5/19/2016
    25-06-2016
    11/27/2016
    5/19/2016
    2/4/2017

    JEE MAINS
    JEE ADV
    GATE
    CAT
    MAINS

    5/19/2016
    25-06-2016
    2/4/2017
    11/27/2016
    5/19/2016

    Marks

    Category rank

    260
    200
    221
    48
    75
    112
    , 73
    46
    112
    17

    601
    985
    2986
    11733
    265
    983
    670
    787
    1270
    559031

    Examination_Duration

    Examination_id

    3 hrs
    2hrs
    2hrs
    3hrs
    3hrs
    2hrs
    2hrs
    3hrs

    INT01,INT02
    ENGG01
    INT01
    ENGG02
    INT01,INT02
    ENGG02
    ENGG01
    INT01

    Result date

    Examination_Duration

    6/14/2016
    8/1/2016
    2/14/2017
    6/14/2016
    5/19/2017

    3 hrs
    3 hrs
    2hrs
    2hrs
    3hrs

    6/14/2016
    8/1/2016
    5/19/2017
    2/14/2017
    6/14/2016

    3hrs
    3hrs
    2hrs
    2hrs
    3hrs

    Ranking

    VERDICT

    765
    260
    3335
    470335
    910
    70333,
    24345
    2435
    70889
    666480

    P
    P
    P
    F
    P
    P
    P
    P
    P
    F

    Marks

    Category rank

    Ranking

    260, 200
    221
    48
    75
    112 , 73
    46
    112
    17

    601, 985
    2986
    11733
    265
    983, 670
    787
    1270
    559031

    765, 260
    3335
    470335
    910
    70333, 24345
    2435
    70889
    666480

    Examination_id

    Marks

    Category rank

    INT01
    ,INT02
    ENGG01
    INT01
    ENGG02

    260
    200
    221
    48
    75

    601
    985
    2986
    11733
    265

    INT01
    ,INT02
    ENGG02
    ENGG01
    INT01

    112
    , 73
    46
    112
    17

    983
    670
    787
    1270
    559031

    VERDICT
    P,P
    P,P
    F
    P,
    P,P
    P,
    P
    F

    RankingVERDICT
    765
    260
    3335
    470335
    910

    P
    P
    P
    F
    P

    70333,
    24345
    2435
    70889
    666480

    P
    P
    P
    P
    F

    You might also like