Database Normalisation

[Blade1889]

I am new to Normalisation and I can't seem to get my head around it.

Can Someone help me with this:

I need to make this UNF in to 1NF,2NF and 3NF as well as adding the resulting entities.
After I have Normalised i then need to create a partial ER Diagram of the Normalised Form.


THE UNF IS CURRENTLY:

Session Date
School Session
Start Time
End Time
Student Name
Attended
Actual Hours
Total Cost
Transport
Notes

If Someone can help it would be massive help

Thanks

 

[The_Doc_Man]

This looks suspiciously like someone's school assignment.

I'll give you some guidelines, but since neither get paid nor get school credits, I won't do it entirely for you.

You need to identify the different things that you are tracking. On first glance, you are tracking students, sessions, and some things that aren't so clear. It appears from the JPG that individual classes within year-sessions might also be tracked.

If you cannot separate out the individual entities you are tracking, you can't track them or normalize them. Therefore, make it a point to understand what (separate) things you are tracking, because each separate type of thing will have its own table. From that starting point, you define the relationships between these entities and can begin to assert normalization.

 

[jdraw]

Further to The Doc Man's advice, here are a couple of links to tutorials that will lead you from a problem description, through a procedure to identify entities, attributes and relationships, and lead you to a solution. Each tutorial takes about 40 minutes. You have to work through them to get the benefit, and what you learn can be used with/for any database.

Class Information tutorial
Consolidated Widgets tutorial

For additional info:
watch this from Daniel Soper and also #2 and #4 in his series on Database

Good luck.