CS145 - Spring 2003
Introduction to Databases
Homework 1 Questions and Answers
- For Challenge problem 2, you should not assume that the highest rank will always be 1. For example, the rank could be relative to a league that reaches beyond the group recorded in the tables.
- For Challenge problem 2, if your expression is becoming large (or even otherwise) it is perfectly acceptable to break it into pieces. For example:
T= SELECT[b > 12] (A)
S = SELECT[c >12](D)
Answer = T JOIN S
- For 1 when we say relational schema, we mean one or more relations, ie all relations into one DTD.
CS145 Web pages -
email the staff