COM 3315 Database Systems - Spring 2002 - Assignment #1

Professor Futrelle -- College of Computer Science, Northeastern U., Boston, MA

[Version of 3/27/2002]


This first written assignment, Assignment #1 is due Tuesday April 2nd, and consists of writing out answers to the questions below either via email or in hardcopy.

Question 1 is a "warmup" problem. Though simple, the answers must be done and turned in too.

1. Consider the sets Sweaters, Balloons and BeachBalls

Sweaters has members described by color and style.

Balloons has members described by color and size.

BeachBalls also has members described by color and size.

1.A Write out the members of BeachBalls UNION Balloons.

1.B Write out the members of Sweaters JOIN Balloons. We could call the resulting set, "MatchingOutfits". What might be good names for the resulting attributes?


2. Do Exercise 2.1(b) in your textbook.


3. Do Exercise 2.1(d) in your textbook.


2. Do Exercise 2.4(d) in your textbook.


2. Do Exercise 2.5(b) in your textbook.


2. Do Exercise 2.5(h) in your textbook.


2. Do Exercise 2.5(n) in your textbook.


2. Do Exercise 2.5(p) in your textbook.


Go to COM3315 home page (Gateway)

Return to Prof. Futrelle's home page