Exam 2 study guide

Notes:

week04notes01, week04notes02, ERDIntro, ERDPractice

Labs:

4, 5

Concepts:

Inner Joins

Covered on last exam, but reviewed here as well.

Outer Join, Union

Given two small relations and SQL doing an outer join (both left and right) or Union, be able to show the resulting relation.

Entity Relationship modeling:

Degree

Cardinality (min and max)

Relationship notation

Weak entities

Recursive Relationships

ERD Practice Exercise

4.30 on p. 249 of the text

“Problem 4.30 Solution” on the top page of the cs360 moodle site shows the book’s answer to this problem, but please try it before looking at the answer.