How to normolize the database by 5 state of normalization?

Question

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.

Upendra Pratap Shahi · 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"

Joe Wilson · Answer

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.

Upendra Pratap Shahi · Answer

Your welcome dude!! Thanks for appriciation. kindly give your link.

Joe Wilson · Answer

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.

Joe Wilson · Answer

Thank you for your answer, by the way, is it important to pay attention to all forms while creating databases of normalizations or not?

Upendra Pratap Shahi · Answer

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"

Joe Wilson · Answer

Thank you for your suggestion.

Joe Wilson · Answer

Thank you for your help , the websites are helpful.

Nanhe Siddique · Answer

read this links http://en.wikipedia.org/wiki/Database_normalization it may help you

Shubham Kumar · Answer

Hi, Joe 1st : n ormalization is a process to organize the data into tabular format and n ormalization 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

Dipankar Biswas · Answer

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

Pankaj Kumar Choudhary · Answer

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/

How to normolize the database by 5 state of normalization?

Answers (12)