CMPT 354 Study Guide - Quiz Guide: Message Transmission Optimization Mechanism, Candidate Key, Db Records

• School: Simon Fraser University
• Department: Computing Science
• Course: CMPT 354
• Professor: Jane Huang

Document Summary

**type or hand-write your solutions and submit a hard copy to the csil assignment before 6pm on. A university db contains information about professors (identified by sin) and courses (identified by course id). Professors teach courses; each of the following situations concerns the teaches relationship set. Assume the above situation (b) applies in all subsequent situations. Relationship set teaches : associates professor, course and semester. There is a single candidate key of the teaches relationship, so the primary key is: {sin, The participation constraint can be anything; let say that it is total on professor and course entity sets. 1b) semester does not need to be an entity set here. Teaches is a binary relation between professor and course. 1c) this means total participation from professors and total participation from courses. Because it is still m-to-m, the candidate key remains {sin, cid}.