Page 91 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE
P. 91
Database Management Systems/Managing Database Pawan Kumar, Lovely Professional University
Notes Unit 6: Relational Language and Database Design
CONTENTS
Objectives
Introduction
6.1 Relational Calculus
6.2 Tuple Relational Calculus
6.2.1 Syntax of TRC Queries
6.2.2 Semantics of TRC Queries
6.3 Domain Relational Calculus
6.4 Query-by-Example
6.5 Overview of Design Process
6.6 Entity-Relationship Model
6.7 Constraints
6.8 E-R Diagrams
6.9 ER Design Issues
6.9.1 Use of Entity Sets versus Attributes
6.9.2 Use of Entity Sets versus Relationship Sets
6.9.3 Binary versus n-ary Relationship Sets
6.9.4 Aggregation versus Ternary Relationships
6.10 Weak Entity Sets
6.11 Extended ER Features
6.11.1 Class Hierarchies
6.11.2 Aggregation
6.12 Summary
6.13 Keywords
6.14 Self Assessment
6.15 Review Questions
6.16 Further Readings
84 LOVELY PROFESSIONAL UNIVERSITY
