Watson Database Tutorial

Home
Labs
Tutorials
Known Bugs
Schedule
Archive
Members
Contact Information

Query By Relational Example

Generating a Projection

  1. Click on the Project button.
  2. Click on the word Relation.
  3. Select a relation.
  4. Click on the word Attribute 1.
  5. Click on Attribute 2 if more requirements are needed.
  6. Click the View button.

A projection with two attributes.

Generating a Select

  1. Click the Select button.
  2. Click on the word Relation.
  3. Select a relation from the list.
  4. Click on the word Attribute.
  5. Select an attribute from the list.
  6. Click on the word Operator.
  7. Select an operator from the list.
  8. Click on the word Value.
  9. Select a value from the list.
  10. Click the View button.

A Select from the Students relation where SNAME is greater than "Garrett D."

Generating a Join

  1. Click the Join button.
  2. Click on the word Relation1.
  3. Select a relation from the list.
  4. Click on the word Relation2.
  5. Select a relation from the list.
  6. Click the word Shared Attribute.
  7. Select an attribute.
  8. Click the View button.

A Join of the Students and Grades relations by ID.

<< Back

Back to Tutorials

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.