Relational Algebra II

Learning Objectives

Describe the purpose of the following relational operators
- Cartesian product (\(\times\))
- natural join (\(\bowtie\))
Manipulate relational data using the aforementioned operators

How to Complete this Lesson

Complete the following learning activities: (2.25 hours total)

Attend the class meeting (60 minutes)
- Complete the practice exercises
Take the quiz (10 minutes)
Work on the schema design for the project (60 minutes)
- Ensure that the schema satisfies Third Normal Form (3NF)

Due

As a reminder, the following is due this lesson:

Quiz: Relational Algebra

Resources

Cartesian product (Wikipedia)
Relational algebra (Wikipedia)
- set operators
- natural join
Questions for the relational algebra (30–45 minutes)