QMS 202 Lecture Notes - Lecture 14: Third Normal Form, Second Normal Form

• School: Ryerson University
• Department: Quantitative Methods
• Course: QMS 202
• Professor: Boza Tasic

Document Summary

If you have any questions comment down and please upvote thanks: the primary key for the given relation is student course number } id the diagram showing all functional dependency is: student student team. Number name compus | campus maja id course course instru insts mar title id office study name id 14 8) a functional dependency x- yis partial fd it. *is prime attribute ire part of key a fd x-r is transitive fd if tis non partial student student name year of study, campus, compus name. key. Campus name in inf. c) the be done by taking transitive fd"s are: campus id " instructor id " in"structor office relation is given to already for 2nf, we need to temove all partial fd. Thu"s can closure calf and of partialf forming separate relation student 3* { student, student recente y campusro, como con major . Rool student student study year, major { number no.