ECE356 Study Guide - Midterm Guide: Relational Algebra, Foreign Key, Referential Integrity

• School: University of Waterloo
• Department: Electrical and Computer Engineering
• Course: ECE356
• Professor: Wojciech Golab

Document Summary

Instructions: (1) print your name and student id at the top of all pages and on the cover page below. Time allowed: 80 minutes (2) the examination paper is 7 pages long (including this cover page). Check that you have all of them and let the proctors know immediately if you are missing any pages. (3) answer the questions in any order. Read an entire question before you begin to answer it. (4) write your answer in the space provided. If you need more space, you may use backs of pages. Course staff will not comment on the correctness, clarity, or soundness of your solutions during the exam. (9) questions vary in difficulty and weight. A restaurant would like to construct a database of their food and beverage menu. Each dish has a name, price, weight, and category (e. g. , appetizer, entr e, dessert). Each beverage has a name, price, weight, and temperature (e. g. , hot or cold).