January 6, 2016 at 2:53 am
"classes" ... "students"
Hmmm, lemme guess. Homework assignment?
If your teacher didn't manage to explain normalization well enough, then perhaps I can help you. Go to Pluralsight.com, sign up for a free trial account, and go watch my course on relational database design. You can skip most of the introduction (that is mostly a historic perspective), but the rest might be relevant. The most important modules to watch are the two "basic normalization" modules.
(The very short synopsis of what you'll learn is to not jump straight into designing tables or even ER diagrams, but to start with a visualisation of the data in a more concrete way, e.g. using diagrams, archive cards, or anything that works for you and -more important- works for the domain expert [for a homework assignment the domain expert is usually just you playing his/her role]. Then follow some guidelines to make modifications to the examples and see if they are still valid - that's how you will discover the functional dependencies. Once you know the functional dependencies, finding the correct relational design is simple).
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply