Relational Algebra and Calculus
Review
Physical Design Decisions
When to Index
When to Use Indexes
RAID Technology
Raid 0
RAID-1
RAID-2
RAID-3
Raid-4
RAID-5
Integrity Constraints
Today
Relational Algebra Operations
Select
Project
Product
Union
Intersect
Difference
Join
Outer Join
Divide
ER Diagram: Acme Widget Co.
Employee
Part
Sales-Rep
Customer
Invoice
Line-Item
Join Items
Relational Algebra
Relational Calculus
SQL
SELECT
Email: ray@sherlock.berkeley.edu
Home Page: http://sims.berkeley.edu/~ray
Download presentation source