Shared Flashcard Set

Details

Title

UCLA CS 143 Final Study

Description

A couple cards for Cardenas' CS 143 ('12W)

Total Cards

Subject

Computer Science

Level

Undergraduate 2

Created

03/20/2012

Click here to study/print these flashcards.

Create your own flash cards! Sign up here.

Additional Computer Science Flashcards

Term

semi-join

Definition

Join A & B, but exclude all columns from B except join columns

Term

composition join

Definition

Join A & B, then exclude the joining domain

Term

outer join

Definition

An left outer join preserves elements in the left table that don't match the right table, filling in the right side with NULL values.

Term

equijoin

Definition

Basically a simple join (could be different-named columns)

Term

division

Definition

A (binary S:T) divided by B (unary T) produces values of S in A with matching T values.