Normalization

Question

Post reply

Normalization

sadhwanipankaj

Valued Member

Points: 56
More actions
March 30, 2010 at 1:19 am

#143723

Hi guy's,
I really Need Some example to do normalized database....
Thanks,
Pankaj
"Born TO Learn"

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

vidya_pande SSCertifiable Points: 5275 More actions · Answer 1

please search for basics of normalization on internet and read it.

sadhwanipankaj Valued Member Points: 56 More actions · Answer 2

will you please give me an full proof example of this ...i have searched on internet but didn't got good example

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 3

Click:A Normalization Primer[/url] and From MSDN

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

marerose888 Old Hand Points: 317 More actions · Answer 4

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

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 5

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;-)

mally.arjun Grasshopper Points: 21 More actions · Answer 6

Read this

http://www.sqlservercentral.com/blogs/abhijit_desai/2010/09/07/noramlization/

Keith Tate SSCrazy Eights Points: 9938 More actions · Answer 7

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[/url]

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 8

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