大二下复习数据库summary of the course.pptxVIP

Summary of the course;DB system Architecture;Data Model;The Entity-Relationship Model;Relational Model;ER Diagram to Relation Schema;Query Languages;SQL;Relational Algebra;Conversion between SQL and RA;Privileges in SQL;Boyce-Codd Normal Form;Third Normal Form;Closure of Attribute Sets;Example of Attribute Set Closure;Uses of Attribute Closure;3NF Decomposition Algorithm;BCNF Decomposition Algorithm;Decomposing a Schema into BCNF;补充材料-无损连接检验;p1={AB,BC}; F={A?B, C?B}, ;Measures of Query Cost;Selection Operation A1-A7 Join Operation Nested-loop join Block nested-loop join Indexed nested-loop