Help with normalization.

[gunnerz]

I've done an ERD and now I have to go through the stages of developing my database. Everything I've done up to this point is about car sales or schools for example: Faculty, lectures, tutorials, tutors etc. But now I'm doing one about sports and it's thrown me off a bit. I guess the one thing that I'm really finding hard even before I start the "hard" part of my assignment is just going from the ERD and then normalizing it. I've read over this tutorial that was posted in response to a question similar to mine. It's helped me understand what's happening but again when I'm trying to apply the skills to my task I'm just getting frustrated. I've been told that Databases just sort of grows on you and you just most things need to work at it. But I just keep getting stuck.

Tutorial that I read: w ww.access-programmers.co.uk/forums/showthread.php?t=100211

Also I've gone over my lecture slides but I'm struggling to really follow them because they just don't seem to tell you a clear course of action, you know do this, then this, then this, then this. I also understand dependencies. Like for example tutorials are fully dependent on subject as in order to tutor someone you need to tutor them on a subject however lecture and tutorials are not dependent on each other as if a tutorial gets cancelled or a lecture cancelled you can still have tutorials.

I understand foreign keys etc. I'm really just struggling on how to go from UNF to 1NF and then onward. For example City will contain Venues, but Teams, will include player data, games, city. Sport I'm not sure that's the whole thing though, and then league is just one table within sport.

Here is my ERD and below it is the example data they've given me. My data is exactly the same just different names etc. I've done mine on Football (soccer) and my league is the EPL.

h ttp://i.imgur.com/TULsA.jpg
h ttp://i.imgur.com/qZHiX.png

"Based on your conceptual model from Part A, normalise the data shown in sample Game Fixture/Result above. Your submitted normalisation must show all stages i.e. UNF to 1NF to 2NF to 3NF. As part of this normalisation, at each stage, you are required to show all functional dependencies"

After this I have to do a Logical model so if someone knows some really good links to tutorials that explains logical model design really well I'd appreciate it so much.

Thank you!

EDIT 1: Also because I don't have 10 posts I can't post links or images so I had to put a space in both links. Sorry I know this is a breach of the rules. Thank you all for you time.

EDIT 2: Hey I've been working on it and I think just logically something that I'd see at 3NF would be something like this?
FIXTURE(Game_ID, Date, Start_time, Venue)
GAME(Game_ID, Team1, Team2,)
RESULT(Game_ID, Result)
WINNER(Game_ID, Winner)

 

[jdraw]

Review these

http://www.databasedev.co.uk/football_soccer_data_model.html

Here are some free video tutorials that describe the processes of data modelling, normalization and entity relationship diagramming. There are other videos, but this group is by the same presenter and covers an example situation.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

The first few topics at this site are well worth the read.

http://www.rogersaccesslibrary.com/forum/topic238.html

Good luck with your project.

 

[gunnerz]

Thanks mate I ended up doing my Logical Model quite easily.

 

[jdraw]

Thanks for posting back. Glad you got your ERD done and that the videos were useful.