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 |
|
Vishal_sql
Posting Yak Master
102 Posts |
 Posted - 2012-06-22 : 07:37:54
|
| Hi All,Is there any way or any query to know at what level database is normalized?eg:- suppose if xyz person is allowed to work on one DB , how can we know is that DB normalised and if yes then till what level |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-22 : 07:55:45
|
| By knowing what normalisation is, knowing what the data represents and looking at the database structure.Note that normalisation is a theoretical concept - whether any level is good for any part of the database depends on how it is to be used (well there are some things that are probably always good but..)==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
Vishal_sql
Posting Yak Master
102 Posts |
Posted - 2012-06-23 : 08:02:37
|
| Thanks again Swepeso ,and nigelrivett as well. From both of your comments it seems that one should go and dig into the DB to find whether DB is normalized by knowing and following NOrmalization. |
|
|
|
|
|
|
IS DB Normalized