Comp 305-001/488-305: Database Administration

Spring 2018: Tuesdays, 4:15-6:45, Comm 013

Week 5


Review ER diagrams
    University DB entities: student, section, course. Relationships: grade_report, prerequisite

A few simple select-based functions

union/intersect
    Review Names of employees who have worked on project 2 OR project 3

More on explain, particularly in the context of joins, possibly with where-conditions

sql2.html:



Installation assignment: