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

Normalization Expand / Collapse
Author
Message
Posted Tuesday, March 30, 2010 1:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, July 14, 2012 8:03 AM
Points: 2, Visits: 22
Hi guy's,
I really Need Some example to do normalized database....
Thanks,
Pankaj
"Born TO Learn"
Post #892497
Posted Tuesday, March 30, 2010 1:26 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, May 11, 2014 8:07 PM
Points: 891, Visits: 235
please search for basics of normalization on internet and read it.


Post #892503
Posted Tuesday, March 30, 2010 2:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, July 14, 2012 8:03 AM
Points: 2, Visits: 22
will you please give me an full proof example of this ...i have searched on internet but didn't got good example
Post #892547
Posted Tuesday, March 30, 2010 5:30 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:11 AM
Points: 2,840, Visits: 3,976
Click:A Normalization Primer and From MSDN

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #892619
Posted Tuesday, August 24, 2010 6:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 16, 2011 12:24 PM
Points: 9, Visits: 22
Boy I am with you on that one. I have been researching for several hours all over the internet and I can't find a sql plan that works. I have never heard of anyone creating separate tables when you have repeating groups....for one thing the repeating groups are field names that general are associated with a metric and the additiona table doesn't make sense. You want to privot the repeating groups into one field and associate a row and metric for each repeating group. The good ETL tools do it great, I just want to know what the pivot code looks like and how it could work.

Actually since I don't have access to SQL Server I would like to know how you would perform a pivot in MS Access....any ideas??

Mare
Post #974549
Posted Tuesday, August 24, 2010 9:55 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:11 AM
Points: 2,840, Visits: 3,976
marerose888 (8/24/2010)
Boy I am with you on that one. I have been researching for several hours all over the internet and I can't find a sql plan that works. I have never heard of anyone creating separate tables when you have repeating groups....for one thing the repeating groups are field names that general are associated with a metric and the additiona table doesn't make sense. You want to privot the repeating groups into one field and associate a row and metric for each repeating group. The good ETL tools do it great, I just want to know what the pivot code looks like and how it could work.

Actually since I don't have access to SQL Server I would like to know how you would perform a pivot in MS Access....any ideas??

Mare
You should start a new thread(topic) for your query


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #974606
Posted Tuesday, October 29, 2013 12:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 29, 2013 12:35 PM
Points: 1, Visits: 5
Read this
http://www.sqlservercentral.com/blogs/abhijit_desai/2010/09/07/noramlization/
Post #1509531
Posted Tuesday, October 29, 2013 2:03 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 11:59 AM
Points: 594, Visits: 933
sadhwanipankaj (3/30/2010)
will you please give me an full proof example of this ...i have searched on internet but didn't got good example


First off there is no "fool proof" when it comes to normalization. There are defined rules, but the interpretation of those rules varies widely. Can you provide more details on what you are looking to do? Is it just to learn about normalization? If so, then there are already some good links on this thread. Do you need to normalize an already existing database? and why?

If you can expand on your question someone should be able to help you with this.




Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1509560
Posted Wednesday, October 30, 2013 6:33 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:50 AM
Points: 922, Visits: 1,444
http://support.microsoft.com/kb/283878

http://databases.about.com/od/specificproducts/a/normalization.htm

Universities devote a few weeks a semester of a database class to normalization, so it will take you some time to learn and practice. At least back when I was in university.

The internet search doesn't take too long.

Do a search for Boyce-Codd Normal Form. In the past, this was considered the goal for normalization (3rd normal form). Like everything in IT, it DEPENDS on the specific database and performance considerations as to whether or not to "normalize" or not.


Steve




Post #1509742
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse