CODEWITHSUNDEEP
relational-databasenormalization
Salim JB
Salim JB

Reputation: 41

Normalize to 3NF

Item_ID   Valuer   Company   value
99       Jon Lane  Lite As  3000
99       Ray dell  Hatches   3500
99       Grace Red  Webb      3000
99       Hell Sim  Chris     4000

I made item_Id and Valuer as the (composite)primary key.

Help on me normalizing to the 3nf. And this is no homework but something I'm working to improve my normalization skills. Found most tables easy to normalize but this one had me.

Upvotes: 0

Views: 145

Answers (2)

Codelearner
Codelearner

Reputation: 251

From the data given I can draft FD as below:

(item_Id,Valuer) -> (company,value)

As the (item_Id,Valuer) is PKey which is also Super key .

So it satisfied 3nf constraint that for FD X-> A X should be SKey.

So its in 3NF.

Upvotes: 0

Erwin Smout
Erwin Smout

Reputation: 18408

Assessing which NF a database design is in, requires knowledge of the FDs that apply. Where are those ?

Upvotes: 1

Related Questions