CS430/630 Relational Algebra Lab   NAME: ________________
(3 points) 

UNIX/Linux Commands we need to use.
1. After logging on topcat.cs.umb.edu, give the command (using cat or more) to display your .forward file. This file contains your preferred email address, so that email addressed to user@cs.umb.edu will be sent to the right place.

2. Give the command to change directory from your login directory to your cs630 directory:

3. Give the command to display the filenames in the directory once there.

4. Give the command to change directory back to your login directory from your cs630 directory.

Relational Algebra 
sailors(sid, sname, rating, age)
reserves(sid, bid, day)
boats(bid, name, color)

Example 0:                                                                Example 1.
Find names of who have ratings at least 8.                 Find names of sailors who've reserved boat 103
Answers (various forms, all OK) 
                                                                                    πsnamesidbid=103Reserves))⨝Sailors)
πsnamerating>=8 Sailors)                                            πsnamebid=103Reserves)⨝Sailors)
πsnameσrating>=8 Sailors                                               πsnamebid=103Reserves⨝Sailors)
                                                                                     πsnameσbid=103Reserves⨝Sailors
Problems for you to try:
1. Display all names and ratings of sailors of             2. Display sailors' snames and dates of all
    age less than 20                                                           reservations by that sailor.




3. Display sailors' sids, ages and names of all that        4. Find sids of sailors who reserved the boat
   sailor's reserved boats.                                                 named 'Dory'.