How to normolize the database by 5 state of normalization?

Joe Wilson

11y1.5k

I mean I know about normalization forms in sql server but I didn't exactly know how to use this forms in my database and I need some examples to figure out this completely, please guide me.

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
Accepted answer
This is not necessary to follow all the forms for data normalization. If your requirement is fulfill then not necessary.

if this is helpful for you, kindly mark the answer as "Accepted Answer"
0
Joe Wilson11y ago
Well this is my post that I have explained you before.

I mean I have a BANK'S E/R schema and I have 2 queries which I have problem related to solving these queries please guide me to solve the queries.

1: displaying the number and address of branches that have given loan for all of their customers.

2: displaying the name and address of bank that all of their branches have given 10 loans.

0
Upendra Pratap Shahi11y ago
Your welcome dude!!

Thanks for appriciation.

kindly give your link.
+1
Joe Wilson11y ago
Thank you very much, by the way, I have posted a question related to an E/R schema of bank and It contained few queries which I have problem to solve them please have a look to it and guide me to solve them.
0
Joe Wilson11y ago
Thank you for your answer, by the way, is it important to pay attention to all forms while creating databases of normalizations or not?

0
Upendra Pratap Shahi11y ago
Read below article-
http://www.dotnet-tricks.com/Tutorial/sqlserver/756N210512-Database-Normalization-Basics.html
https://www.simple-talk.com/sql/t-sql-programming/database-normalization-basics/
http://www.sqlservercentral.com/blogs/abhijit_desai/2010/09/07/noramlization/

if this is helpful for you, kindly mark the answer as "Accepted Answer"
+1
Joe Wilson11y ago
Thank you for your suggestion.

0
Joe Wilson11y ago
Thank you for your help , the websites are helpful.

0
Nanhe Siddique11y ago
read this links

http://en.wikipedia.org/wiki/Database_normalization

it may help you
+1
Shubham Kumar11y ago
Hi, Joe
1st : normalization is a process to organize the data into tabular format and normalization reduces the data redundancy and inconsistent data dependency.
and secondly

5th Normal form is saying
1. Remove the join dependency.
2.Break the database table into smaller and smaller tables to remove all data redundancy.

just go through with this article you get an idea
http://www.dotnet-tricks.com/Tutorial/sqlserver/756N210512-Database-Normalization-Basics.html
+1
Dipankar Biswas11y ago
Hi...

Check this link...Database Normalization - Explained with Examples

Thanks...
+1
Pankaj Kumar Choudhary11y ago
Hello @Joy you can refers below links

http://www.dotnet-tricks.com/Tutorial/sqlserver/756N210512-Database-Normalization-Basics.html
http://www.studytonight.com/dbms/database-normalization.php
https://sreenivasmsbi.wordpress.com/2012/02/27/sql-server-normalization-forms-with-examples/
+1