| Author |
Topic |
|
quake
Starting Member
3 Posts |
 Posted - 2008-05-15 : 23:54:09
|
| My teacher said that SQL Server can normalize any table to NF3 automatically, but I haven't found it yet. Is my teacher wrong?And how to describe funtional dependencies in SQL Server ?(I'm not good at English) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-16 : 00:11:31
|
| Your teacher is wrong.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
quake
Starting Member
3 Posts |
Posted - 2008-05-16 : 00:28:23
|
| Thanks for reply !But what about the Funtional Dependencies ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-16 : 00:48:10
|
| I'm not sure what you mean.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
quake
Starting Member
3 Posts |
Posted - 2008-05-16 : 01:00:49
|
| With a funtional dependency like " A -> B,C " or " Emp_ID -> Emp_name, Emp_age "Can I describe it in SQL Server ? |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-05-16 : 14:54:17
|
quote:
Originally posted by quake
With a funtional dependency like " A -> B,C " or " Emp_ID -> Emp_name, Emp_age "Can I describe it in SQL Server ?
Yes. They are called "tables"....e4 d5 xd5 Nf6 |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-16 : 16:09:32
|
| "My teacher said that SQL Server can normalize any table to NF3 automatically, but I haven't found it yet"Not sure, Are you talking about UNPIVOT? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-16 : 16:10:55
|
| How would UNPIVOT normalize a table to third normal form?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-16 : 16:18:05
|
| Not to NF3. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-16 : 16:20:37
|
| Exactly, so UNPIVOT doesn't do what the teacher said.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-05-16 : 16:42:45
|
quote:
Originally posted by quake... SQL Server can normalize any table to NF3 automatically...
This would be height of Automation! Still, i won't be surprised if MS comes with such option.------------------------I think, therefore I am - Rene Descartes |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-05-16 : 17:47:27
|
OK, so SQL Server will pick the primary key, remove repeating groups, remove partial dependencies, remove transitive dependencies, and produce a DB in 3NF?Most developers can’t seen to create a DB in 3NF, so I am a bit skeptical of that.  CODO ERGO SUM |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-05-16 : 21:19:55
|
quote:
Originally posted by sodeep
Not to NF3.
Pivot cannot normalize a table to NF3. But it could normalize it toNF3. e4 d5 xd5 Nf6 |
|
|
|
|
Can SQL Server normalize my tables automatically