"i hate normalisation and i cannot lie"

hi people
i am a beginner to normalisation and am having a little trouble going from 2NF to 3Nf .Could n e 1 that reads these forums give me some pointers on which table need normalising to 3rd NF. from what i can see it's just the Author_table and the Reviewers_table that needs it. is this correct?



UNF

Paper No
Paper Title
Decision
Topic

Author’s Name
Email
Phone

Reviewer’s Name
Relevance
Originality
Technical Merit
Overall Mark

Copyright OK
Received OK
Length OK
Format OK



1st Normal Form

Paper table
----------------
Paper No (PK)
Paper Title

Decision_table
----------------
Decision_id (PK)
Decesion

Paper_Topics_table
----------------
Topic_id (PK)
Topic

Author table
----------------
Author_id (PK)
First Name
Surname
Email
Phone

Review table
----------------
Review_id (PK)
Relevance
Originality
Technical Merit
Overall Mark



Reviewers_table
----------------
Reviewer_id(PK)
Reviewer’s First Name
Reviewer’s Surname
Phone
Email


Manuscript table
----------------
Manuscript_no(PK)
Copyright OK
Received OK
Length OK
Format OK

2nd Normal Form

Paper table
-------------
Paper No (PK)
Paper Title

Decision_table
---------------
Decision_id (PK)
Decesion

Paper_Topics_table
--------------------
Topic_id (PK)
Topic

Author table
--------------
Author_id (PK)
First Name
Surname
Email
Phone

Review table
---------------
Review_id (PK)
Relevance
Originality
Technical Merit
Overall Mark


Reviewers_table
------------------
Reviewer_id(PK)
Reviewer’s First Name
Reviewer’s Surname
Phone
Email

Reviewer_Topic Table
---------------------
Reviewer_id(PK)
Topic_id

Manuscript table
---------------
Manuscript_no(PK)
Copyright OK
Received OK
Length OK
Format OK

I see only one relationship between the entities. How are the entities related?

hi
thanks for your reply - as i said i am very new to normalisation. but here is the scenario i have been given.

any help to tell me where i'm going wrong would be great.

-----------------------------------------------------------------------
A database is required for supporting the administration of conference proceedings identified below.
Prospective authors submit papers, which have to be distributed to Programme Committee Members (PCM) for review. Each PCM is willing to review a (unspecified) number of papers that concern a number of (specified) chosen topics. Information stored on topics have a unique topic number and topic name. Each paper has a keyword to state which topic it discusses and must be reviewed by at least one PCM.
The database is to be used for tracking the progress of the review process, sending reminders to late reviewers, and recording information resulting from the reviews for discussion at the program committee meeting and to decide which papers should be accepted. To this end the reviews contain marks out of ten for originality, technical merit, relevance to this particular conference and an overall mark. When all reviews have been returned, the program committee meets and makes their decision as to which papers are to be selected. Letters are then sent, including the reviews, to authors of both the accepted and rejected papers. Then the final manuscripts for accepted papers start to arrive. The database is to be used to record problems such as missing copyright transfer forms, the paper being longer than allowed, formatting problems etc. Authors have to be contacted to correct any such papers and to hurry them along if they are late. Finally, the database is used to extract information for entry into the proceedings: table of contents (listing of papers, authors names) and a list of PCMs’ names for inclusion in the introduction of the proceedings.
--------------------------------------------------------------------------

i was also given UNF

Try to think about the model as one large table first.

Then move into first normal form making sure to maintain inferred relationships.

For example:

UNF(Student, Course1, Instructor1, Course2, Instructor2)

Student(Student(PK))
Course(Course(PK),Instructor,Student(FK))

The inferred relationship is student.

no offence but thats not rally much help.

what does that mean in terms of my relationships?

Treat the UNF as one table. Then break it up preserving the inferred relationships.

Paper(PaperID, AuthorID(FK), etc)
Author(AuthorID, etc)

I'm trying to help, but I'm not going to do your work.

Here's an article on normalization

here's more info http://www.utexas.edu/its/windows/da.../datamodeling/