Is this table schema normalized to 1NF and where can I improve?

Question

I've been trying to normalize these tables to 1NF and think I may have done it but was looking for someone to confirm that it's 1NF, all the datatypes look correct and the crows foot look correct? Here it is: http://i67.tinypic.com/xdy07s.png The tables represent a behaviour report card system for a school which rates the student on various bahaviour attributes and rates them out of 10. Please and thankyou! Napstur

Answer 1

Short answer: yes, this scheme satisfies 1st NF

A little longer explanation:

1st NF demands that every row in tables are unique.

Look at the scheme you posted: do you see "PK" signs?

"PK" means Primary Key, so this scheme automatically satisfies 1st NF.

And now you can start think about more correct question: "Is this 3rd NF or BCNF or even 4th NF?"

Answer 2

Looks like first normal form to me. I see no columns holding multiple values and no repeating columns.