开发者

Normalize the following scenario

开发者 https://www.devze.com 2023-01-19 14:19 出处:网络
A college keeps details about a student and the various modules that the student has stud开发者_Python百科ied. These details compromise Registration number, Name, Address, Tutor Number, Tutor Name, Di

A college keeps details about a student and the various modules that the student has stud开发者_Python百科ied. 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.


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

0

精彩评论

暂无评论...
验证码 换一张
取 消