Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

can any body explain normalization and types?/ Expand / Collapse
Author
Message
Posted Tuesday, April 23, 2013 1:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:08 AM
Points: 68, Visits: 409
can any body explain normalization and types?
Post #1445304
Posted Tuesday, April 23, 2013 2:31 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 9:02 AM
Points: 702, Visits: 2,171
Thats a bit too deep to go into for a forum post.

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

Read that. Look at section 3 Normal Forms. Each of those has a link to an explanation of each one. Read the ones you're interested in. 3NF is probably the one you want.

Having read those if you have any questions then post back and I'm sure someone will be able to answer your question.




MCSA: SQL Server 2012
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1445313
Posted Tuesday, April 23, 2013 8:22 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:21 PM
Points: 13,083, Visits: 11,918
Here are a couple others.

http://www.sqlservercentral.com/articles/Stairway+Series/The+Relational+model+and+Normalization./74134/

http://www.sqlservercentral.com/articles/Normalization/74241/

http://www.sqlservercentral.com/articles/74381/

http://www.sqlservercentral.com/articles/Normalization/74437/


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1445464
Posted Tuesday, April 23, 2013 9:59 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:36 PM
Points: 23,009, Visits: 31,509
You really need to understand the first three normal forms. It is good to have an understanding of the others, but the first three are critical IMHO.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1445547
Posted Monday, April 29, 2013 1:07 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 21, 2014 6:24 AM
Points: 3,537, Visits: 2,647
Hi Gurjer48,
Just open google, type normalization and hit enter and you'll have thousand links to know about Normalization. You can search out here in sqlservercentral as well.
Post #1447383
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse