POS/410 Week 1 – On-Ground
Lecture – The Projects Database
Here is a diagram of our projects database for reference in using the SQL scripts in the other lectures. Works_on is an intersection table linking the employee and project tables. Employee has a recursive relationship via the supervisor ssn
Dan
D'Urso
Laguna Niguel, CA
April 2005