Watson Database Tutorial


Home
Labs
Tutorials
Known Bugs
Schedule
Archive
Members
Contact Information

Query By Example

Generating a Relation

  1. Click the Relation button.
  2. Select a relation from the list in the pop-up box.
  3. Select the attributes you want by clicking on the check boxes.
  4. Assign any operators or values.
  5. Click the View button to generate the relation.

A projection from the Students relation where SNAME and AGE are greater than 21.

Generating a Join

  1. Select the first relation in the join operation.
  2. Click the Join button.
  3. Select the second relation in the join operation.
  4. Select the common attribute.
  5. Click the View button.

A Join of the Students and Grades relations, associated by ID.

<< Back

Back to Tutorials

Next >>



Home | Labs | Tutorials | Known Bugs | Schedule | Archive | Members | Contact Information

For problems or questions regarding this site or the labs, contact the Watson Project.
Last updated: 10/22/03.