Copyright 2004 Pearson Education Inc Chapter 6 The Relational Algebra and Relational Calculus Copyright 2004 Pearson Education Inc FIGURE 6 1 Results of SELECT and PROJECT operations a DNO 4 AND SALARY 25000 OR DNO 5 AND SLARY 30000 EMPLOYEE b SEX SALARY EMPLOYEE Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 3 FIGURE 6 2 Results of a sequence of operations a FNAME LNAME SALARY DNO 5 EMPLOYEE b Using intermediate relations and renaming of attributes Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 4 FIGURE 6 3 Results of the UNION operation RESULT RESULT1 RESULT2 Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 5 FIGURE 6 4 The set operations UNION INTERSECTION and MINUS a Two union compatible relations b STUDENT INSTRUCTOR c STUDENT INSTRUCTOR d STUDENT INSTRUCTOR e INSTRUCTOR STUDENT Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 6 FIGURE 6 5a The CARTESIAN PRODUCT CROSS PRODUCT operation Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 7 FIGURE 6 5b The CARTESIAN PRODUCT CROSS PRODUCT operation Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 8 FIGURE 6 5c The CARTESIAN PRODUCT CROSS PRODUCT operation Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 9 FIGURE 6 6 Result of the JOIN operation DEPT MGR DEPARTMENT JOIN MGRSSN SSN EMPLOYEE Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 10 FIGURE 6 7 Results of two NATURAL JOIN operations a PROJ DEPT PROJECT DEPT b DEPT LOCS DEPARTMENT DEPT LOCATIONS Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 11 FIGURE 6 8 The DIVISION operation a Dividing SSN PNOS by SMITH PNOS b T R S Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 12 FIGURE 6 9 The AGGREGATE FUNCTION operation Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 13 FIGURE 6 10 A two level recursive query Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 14 FIGURE 6 11 The result of a LEFT OUTER JOIN operation Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 15 FIGURE 6 12 A relational database schema for a LIBRARY database Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 16 FIGURE 6 13 A database state for the relations T1 and T2 Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 6 17
View Full Document
Unlocking...