DBMS Normalization Query

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

DBMS Normalization Query

shivambhatele
Hello All,

I am looking to explore more about normalization in DBMS. I am confused
about some points. Can anyone tell me about these points? I have to google
it to read about all these points and I have found some blogs like this
normalization in DBMS <https://hackr.io/blog/dbms-normalization>   but
still, I am not cleared some points

1. When is the process of normalization used?
2. Boyce and Codd Normal Form
3. 1NF, 2NF, and 3NF





--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: DBMS Normalization Query

Chris Locke-3
Short answer.  Duplicate data in a database is bad.  Take school
departments.  For each teacher, do you put "History", "Chemistry",
"Biology" for their department?  What happens if someone enters "Bioolgy"
instead?  So for your point #1, "as soon as duplicate data is possible".
Maybe not for surnames or firstnames, but certainly for address counties,
departments, car types, etc, etc.  As soon as there is a definite list for
some data.
#2, #3.  Wikipedia is your friend here.

On Thu, Oct 3, 2019 at 2:47 PM shivambhatele <[hidden email]>
wrote:

> Hello All,
>
> I am looking to explore more about normalization in DBMS. I am confused
> about some points. Can anyone tell me about these points? I have to google
> it to read about all these points and I have found some blogs like this
> normalization in DBMS <https://hackr.io/blog/dbms-normalization>   but
> still, I am not cleared some points
>
> 1. When is the process of normalization used?
> 2. Boyce and Codd Normal Form
> 3. 1NF, 2NF, and 3NF
>
>
>
>
>
> --
> Sent from: http://sqlite.1065341.n5.nabble.com/
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: DBMS Normalization Query

James K. Lowden
In reply to this post by shivambhatele
On Wed, 2 Oct 2019 21:42:13 -0700 (MST)
shivambhatele <[hidden email]> wrote:

> 1. When is the process of normalization used?
> 2. Boyce and Codd Normal Form
> 3. 1NF, 2NF, and 3NF

Good information on database theory is remarkably scarce on the web,
and difficult for the beginner to distinguish from bad information on
database theory.  And, actually, that's the case for almost any body of
knowledge.  If you want to master a discipline, books are a better
resource.  

I have tried referring people to wikipedia before.  It's not
necessarily wrong; it's more a question of completeness and explication.
You just can't replace a book with a web page or pages.  

I recommend

        An Introduction to Database Systems (8th Edition), 2003,
        by C.J. Date

It's useful to understand normalization in the context of relational
algebra: by removing redundancy, you defend against anomalies that
would otherwise result from mathematically correct operations.  So,
well, more than one chapter to read.  :-)  

--jkl
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users