Lab 04 - Relational Algebra
Answer the following questions from the text:
Chapter 6
Exercises 6.10, 6.11, 6.14
When writing your answers, you should use the relational algebra synbols.
If you don't know how to enter special characters on your keyboard, You may copy and paste them from here:
- Select σ
- Project Π
- Union ∪
- Set difference −
- Cartesian product ×
- Rename ρ
- Set intersection ∩
- Natural join ⨝
- Left outer join ⟕
- Right outer join ⟖
- Full outer join ⟗
- And ∧
- Or ∨
- Not ¬
Make sure your answers are in complete sentences. Here's a good answer to the question "What should the primary key for the candy relation table be?":
The primary key for the candy relation should be "candy_id".Here's a bad answer:
candy_id