Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
monkeys123
Starting Member
7 Posts |
 Posted - 2014-07-08 : 22:39:48
|
| where can i find a good normalization tutorial? i already google it but i only find the concept witch i do understand, what i need to know is how to get repeated data from a existing table, to normalized tables with out typing it...example:---------------------| ID |TEXT | TAGS |---------------------| 1 |text1|repeating|| 2 |text2|repeating|----------------------how to normalization would be use 3 tables ,one for tags_id and tags, and another relating the tags_id to ID from the table above...but how does the code already know there is a tag called repeating? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
monkeys123
Starting Member
7 Posts |
Posted - 2014-07-10 : 18:54:47
|
quote:
Originally posted by SwePeso
See https://www.simple-talk.com/sql/database-administration/the-road-to-professional-database-development-database-normalization/
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
i read it but i still dont get THE CODE to import, not create the tables, everyone talks about the theory and type the data, i want to get a unormalized table and normalize it .-. can u point me a code example? |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
|
|
|
|
|
|
|
help me understand normalization