Re: [sqlite] DBMS Normalization Query

On Wed, 2 Oct 2019 21:42:13 -0700 (MST) shivambhatele 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

Re: [sqlite] DBMS Normalization Query

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

[sqlite] DBMS Normalization Query

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