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