final-review - EEL4852 Final review Fall 2008 Dr Yicheng Tu...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
EEL4852 Final review Fall 2008 Dr. Yicheng Tu I. Chapter 1 - Introduction 1. Desirable characteristics of database systems (advantages over file systems) 2. Instances and schemas II. Chapter 5 - Relational algebra (focus on rules/assumptions) 1. Select 2. Project 3. Union 4. Set difference/intersection 5. Cartesian product 6. Rename 7. Natural join, theta join 8. Division 9. Aggregate III. Chapter 8 – SQL 1. Basic structure of SQL queries a. ' select' , ' from' , and ' where' clauses b. Their algebraic equivalence c. Tuple variables in SQL d. Maintain/eliminate duplicates e. Tuple ordering 2. SQL set operations a. Union b. Intersection c. Except (Minus) 3. Aggregate functions a. What are the different types of aggregates b. ' group by' and ' having' clauses 4. Nested subqueries a. Set membership and comparison b. Testing for empty relations V. Chapter 3 – ER design 1. Model components a. Entity sets b. Relationship sets 2. Constraints a. Cardinalities: one/many-to-one/many
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 2

final-review - EEL4852 Final review Fall 2008 Dr Yicheng Tu...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online