
Contents
1
Overview of Relational DBMS
1.1 Concepts of Relational Databases 1
1.2 Integrity Constraints 3
1.3 Normalization 4
1.3.1 Functional Dependencies 5
1.3.2 Normal Forms 7
1.4 Relational Algebra 9
1.4.1 Selection Operation 10
1.4.2 Projection Operation 10
1.4.3 Union Operation 11
1.4.4 Set Difference Operation 11
1.4.5 Cartesian Product Operation 11
1.4.6 Intersection Operation 11
1.4.7 Join Operation 12
1.4.8 Division Operation 14
1.5 Relational Database Management System 14
Chapter Summary 15 • Exercises 15
2
Review of Database Systems
2.1 Evolution of Distributed Database System 19
2.2 Overview of Parallel ...