DATABASE MANAGEMENT SYSTEMS 2.5 Conceptual Database Design With the ER Model 2.5.1 Entity versus Attribute 2.5.2 Entity versus Relationship 2.5.3 Binary versus Ternary Relationships 2.5.4 Aggregation versus Ternary Relationships 2.6 Conceptual Design for Large Enterprises 2. 7 Points to review 3 THE RELATIONAL MODEL 51 3.1 Introduction to the relational model 3.1.1 Creating and Modifying Relations Using SQL-9 Constraints over rela Key Constraints Key Constraints 3.2.3 General Constraints 3.3 Enforcing Integrity Constraints 3.4 Querying Relational Data 3.5 Logical Database Design: ER to relational Entity Sets to Tables elationship Sets(without Constraints) to Tables 3.5.3 Translating Relationship Sets with Key Constraint 3.5.4 Translating Relationship Sets with Participation Constraints 3.5.5 Translating Weak Entity Sets 3.5.6 Translating Class Hierarchies 3.5.7 Translating ER Diagrams with Aggregation 3.5.8 ER to Relational: Additional Examples 3.6 Introduction to views 3.6.1 Views, Data Independe Security 79 3.6.2 Updates on Views 3.7 Destroying/ Altering Tables and Views 3.8 Points to review Part II RELATIONAL QUERIES 4 RELATIONAL ALGEBRA AND CALCULUS 4.1 Preliminaries 4.2.1 Selection and Projection 4.2.2 Set Operations 4.2.4 Joins 4.2.5 Division 4.2.6 More Examples of Relational Algebra Queriesviii Database Management Systems 2.5 Conceptual Database Design With the ER Model 38 2.5.1 Entity versus Attribute 39 2.5.2 Entity versus Relationship 40 2.5.3 Binary versus Ternary Relationships * 41 2.5.4 Aggregation versus Ternary Relationships * 43 2.6 Conceptual Design for Large Enterprises * 44 2.7 Points to Review 45 3 THE RELATIONAL MODEL 51 3.1 Introduction to the Relational Model 52 3.1.1 Creating and Modifying Relations Using SQL-92 55 3.2 Integrity Constraints over Relations 56 3.2.1 Key Constraints 57 3.2.2 Foreign Key Constraints 59 3.2.3 General Constraints 61 3.3 Enforcing Integrity Constraints 62 3.4 Querying Relational Data 64 3.5 Logical Database Design: ER to Relational 66 3.5.1 Entity Sets to Tables 67 3.5.2 Relationship Sets (without Constraints) to Tables 67 3.5.3 Translating Relationship Sets with Key Constraints 69 3.5.4 Translating Relationship Sets with Participation Constraints 71 3.5.5 Translating Weak Entity Sets 73 3.5.6 Translating Class Hierarchies 74 3.5.7 Translating ER Diagrams with Aggregation 75 3.5.8 ER to Relational: Additional Examples * 76 3.6 Introduction to Views 78 3.6.1 Views, Data Independence, Security 79 3.6.2 Updates on Views 79 3.7 Destroying/Altering Tables and Views 82 3.8 Points to Review 83 Part II RELATIONAL QUERIES 89 4 RELATIONAL ALGEBRA AND CALCULUS 91 4.1 Preliminaries 91 4.2 Relational Algebra 92 4.2.1 Selection and Projection 93 4.2.2 Set Operations 94 4.2.3 Renaming 96 4.2.4 Joins 97 4.2.5 Division 99 4.2.6 More Examples of Relational Algebra Queries 100