Home TechnologyProgrammingSQL & Databases Subscribe to RSS

Why Should We Normalise Relational Database?

Answer Question

2 Answers - Sort by: Date | Rating

    A database which is not normalized would have relations of the same data. This means that to update the database you would need to update the same data in several different places. This would tend to slow down the database access and make it larger than it needs to be.
    0 0

    Beeky 

    answered 10 months ago

      That was a very common answer with a practical point of view eliminate redundancy in other words.

      Other more technical answer is that Relational Algebra is equivalent to Predicate Calculus (with closed world assumption and other details not to talk about them now).

      Normalization is needed because it is equivalent to quantification in Predicate Calculus.
      It is not the same to say: For all boys thee exists one girl they are married with  than one girl is married with all boys (polyandry)
      quantifiers for all, exist, exist just one, are very subtle to use. If done careless many mistakes may occur, also with its counterpart in relational algebra, normalization.

      In synthesis:  If you do not normalize your database will not represent the world you want to.
      0 1
      Guest

      Guest 

      answered 8 months ago

        Answer Question - Answers are editable for 5 min.

        If you do not Sign-in or Register your answers will

        be anonymous, your answers may also be

        checked before going online.

        0

        More

           
           

          Ask a Question via Twitter

          Send a question to @askblurtit and we will publish it online and send you a reply everytime you receive an answer.

          Blurtit Store

          Get T-shirts, hoodies, caps and more at the Blurtit store

          Blurtit International