Help : Is This Data in 3NF?

From: David Hammond <david_hammond_at_yahoo.com>
Date: Tue, 17 Apr 2001 17:44:16 GMT
Message-ID: <Qh%C6.273$TF5.76645@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 Tue Apr 17 2001 - 12:44:16 CDT