Results 1 to 4 of 4

Thread: Important in Normalization

  1. #1
    Contributing Member
    Join Date
    May 2006
    Answers
    85

    Important in Normalization

    Hi,
    Normalization refers to removing redundancy of data and there are different types of normal forms say first, second, third and Boyce codd normal form.
    I want to know which of these forms the important normal form is and in real time applications is it possible to have all the four normal forms implemented.

    Regards,
    Norman


  2. #2
    Contributing Member
    Join Date
    May 2006
    Answers
    71

    Re: Important in Normalization

    The achieving of each level of normalization is resulted by passing each level one after the other. Also it does not mean all real applications have all normal forms implemented. It depends on the design of database, usage and many attributes.


  3. #3
    Junior Member
    Join Date
    Aug 2007
    Answers
    2

    Re: Important in Normalization

    What's the difference between BCNF and 3rd Normal form


  4. #4
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Important in Normalization

    3rd n.f.
    -----------
    for a table to be in 3rd n.f. First it should be in 2nd n.f. And remove those column from the table which is dependent upon some other column in a table and that column is not a candidate key column for that table.

    Bcnf-----every determinant is a candidate key

    it is considered as the 4th normal form.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact