Re: Help : Is This Data in 3NF?

i am sure you can find a good tutorial on 3NF and then apply it to your physical model below.

"David Hammond" <david_hammond_at_yahoo.com> wrote in message news:Qh%C6.273$TF5.76645_at_news2.cableinet.net...
> I am designing a database system but I am a little unsure about
> normalisation - could anyone tell me if the information below is in third
> normal form? If it isn't could anyone suggest where I've gone wrong.
>
> Protocol: (Protocol Ref., Title, Guideline Link, URL, Format, Category,
> Abstract)
> Users: (Protocol Ref., User No.)
> User Profile: (User No., First Name, Surname, E-mail, Home Hospital, NHS
> Trust, Position)
> Comments: (Protocol Ref., User No., Date Made, Main Body)
> Dates: (Protocol Ref., Date Created, Next Review, Last Review)
> Author: (Protocol Ref., First Name, Surname, Publisher)
> Other Authors: (Protocol Ref., First Name, Surname)
> Watermark: (Protocol Ref., Authority Score, Organisation)
> Other Protocols: (Protocol Ref., Title, Related Protocol Ref.)
>
> Where Protocol Ref. and User No. are key fields
>
> anyone help would be great
> cheers, dave.
>
>
Received on Sat Apr 21 2001 - 02:33:10 CEST