A college keeps details about a student and the various modules that the student has studied. These details compromise Registration number, Name, Address, Tutor Number, Tutor Name, Diploma Code, Diploma Name and repeating fields for module code and module name and result. Normalize the relation.
+1
A:
There's quite a few resource, like this and this - once you understand it, it'd simple... think in terms of sets of data and you won't go far wrong
Hint - most tables are obvious (answers in the question), you will also need a table that links two of them together
Mr Shoubs
2010-10-07 10:11:44
Good answer: Lead them but don't feed them when it come to stuff that smells strongly of homework.
NealB
2010-10-08 13:46:36
show don't tell ;)
Mr Shoubs
2010-10-11 10:49:26