On Wed, 2 Oct 2019 21:42:13 -0700 (MST)
shivambhatele <shivambhatel...@gmail.com> 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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
