CMPT 354 Study Guide - Quiz Guide: Db Records, Unique Key

• 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. It stores information about employees (identified by sin, with salary and phone attributes) and departments (identified by deptid, with department name and budget as attributes). The db records the interval during which an employee works for a department. Draw an er diagram that describes each of the following situations: employee is not allowed to work in a department for two or more intervals, employee is allowed to work in a department for one or more intervals. Consider the following information about the abc bank: Each branch is located in a particular city and is identified by a unique name.