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 |
|
y0zh
Yak Posting Veteran
60 Posts |
 Posted - 2010-04-24 : 07:46:32
|
Here is the table. COuld you answer, what NF is related to this table?IDNAME CITY DATEB COL PRICE VAL DAT_INS12253141 DAA 4/13/2007 200 447.22 F 4/13/07 5:06 AM12253141 DAA 4/13/2007 200 447.22 F 4/13/07 5:07 AM12253141 DAA 4/15/2007 160 447.22 T 4/13/07 8:06 AM12253141 DAA 4/13/2007 200 447.22 F 4/13/07 5:08 AM12253141 DSA 4/13/2007 180 525.14 F 4/13/07 5:06 AM12253141 DSA 4/13/2007 250 626.18 F 4/13/07 5:06 AM |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-04-24 : 07:49:47
|
| Sorry, i don't understand your question. NF? |
 |
|
|
y0zh
Yak Posting Veteran
60 Posts |
Posted - 2010-04-24 : 08:31:17
|
| I mean Normal Form1NF, 2NF, 3NF |
|
|
|
y0zh
Yak Posting Veteran
60 Posts |
Posted - 2010-04-24 : 08:54:03
|
| Any answer? |
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-04-24 : 09:00:40
|
| obviously you have duplicated in table..it's not 1NF. |
|
|
|
y0zh
Yak Posting Veteran
60 Posts |
Posted - 2010-04-24 : 09:03:21
|
| So, this table is not in 1nf or 2nf or 3nf? |
|
|
|
|
|
|
What normal form for this data?