数据库 ppt modify-ch2课件.pptVIP

Chapter 2: Relational Model;Chapter 2: Relational Model;Example of a Relation;Basic Structure;Basic Structure (Con.);Attribute Types;Relation Schema;Relation Instance;Relations are Unordered;Database;Database (Con.);The customer Relation;The depositor Relation;Keys;Keys (Cont.);Foreign Keys;Query Languages;Relational Algebra;Select Operation – Example;Select Operation;Project Operation – Example;Project Operation;Union Operation – Example;Union Operation;Set Difference Operation – Example;Set Difference Operation;Cartesian-Product Operation – Example;Cartesian-Product Operation;Composition of Operations;Rename Operation;Banking Example;Example Queries;Example Queries;Example Queries;Example Queries;Formal Definition;Additional Operations;Set-Intersection Operation;Set-Intersection Operation – Example; Notation: r s;Natural Join Operation – Example;Division Operation;Division Operation – Example;Another Division Example;Division Operation (Cont.);Assignment Operation;Bank Example Queries;Query 1 ?customer_name (?branch_name = “Downtown” (depositor account )) ? ?customer_name (?branch_name = “Uptown” (depositor account));Find all customers who have an account at all branches located in Brooklyn city.;Extended Relational-Algebra-Operations;Generalized Projection;Aggregate Functions and Operations;Aggregate Operation – Example;Aggregate Operation – Example;Aggregate Functions (Cont.);Outer Join;Outer Join – Example;Outer Join – Example;Outer Join – Example;Null Values;Null Values;Modification of the Database;Deletion;Deletion Examples;Insertion;Insertion Examples;Updating;Update Examples;End of Chapter 2;Figure 2.3. The branch relation;Figure 2.6: The loan relation;Figure 2.7: The borrower relation;Figure 2.9Result of ?branch_name = “Perryridge” (loan) ;Figure 2.10: Loan number and the amount of the loan;Figure 2.11: Names of all customers who have either an account or an loan;Figure 2.12: Customers with an account but no loan;Figure 2.13: