参考教案成果database-a54.pptxVIP

Database System Concepts;DBMS: A System-Oriented Application ;Chapter 2: Introduction to Relational Model;Example of a Relation;Attribute Types;Relation Schema and Instance;Relations are Unordered;Relations are Unordered;Schema Diagram for University Database;Relational Operators;Selection of tuples;Selection of Columns (Attributes);Joining two relations – Cartesian Product;Union of two relations;Set difference of two relations;Set Intersection of two relations;Joining two relations – Natural Join;Natural Join Example;Chapter 3: Introduction to SQL;Create Table Construct;Basic Query Structure ;The select Clause;The select Clause (Cont.);The select Clause (Cont.);The where Clause;The from Clause;Cartesian Product;Joins;Natural Join;Natural Join (Cont.);The Rename Operation;Where Clause Predicates;Set Operations;Null Values;Null Values and Three Valued Logic;Null Values;Aggregate Functions;Aggregate Functions (Cont.);Aggregate Functions – Group By;Aggregate Functions – Having Clause;Nested Subqueries;Example Query;Test for Empty Relations;Correlation Variables;Not Exists;Test for Absence of Duplicate Tuples;Modification of the Database – Deletion;Example Query;Modification of the Database – Insertion;Modification of the Database – Insertion;Modification of the Database – Updates;Atomicity of Updates Concurrent Access;Transaction Management ;Database System Internals