Database

PrefaceChapter 1 Introduction 1.1 Fundamental Database Concepts 1.2 Database Users 1.3 Overview of a Relational DBMS The Relational Model and Query Capabilities Programs to Access a Database Logical Database Design Database Administration Physical Database Design and Performance Database Transactions 1.4 Putting it All TogetherChapter 2 The Relational Model 2.1 The CAP Database 2.2 Naming the Parts of a Database Domains and Datatypes Tables and Relations 2.3 Relational Rules 2.4 Keys, Superkeys, and Null Values Null Values 2.5 Relational Algebra Fundamental Operations of Relational Algebra 2.6 Set-Theoretic Operations The Union, Intersection, and Difference Operations Assignment and Alias The Product Operation 2.7 Native Relational Operations The Projection Operation The Selection Operation Precedence of Relational Operations The Join Operation The Division Operation 2.8 The Interdependence of Operations 2.9 Illustrative Examples 2.10 Other Relational Operations Outer Join Theta JoinChapter 3 Query Language SQL 3.1 Introduction SQL Capabilities SQL History-Standards and Dialects 3.2 Setting Up the Database A Practical Exercise 3.3 Simple Select Statements 3.4 Subselects The in Predicate The Quantified (Comparison) Predicate The Exists Predicate A Weakness of SQL: Too Many Equivalent Forms 3.5 SQL Union and "For All . . ." Conditions The Union Operator The Division Operator: SQL "For All . . ." Conditions 3.6 Set Functions in SQL Handling Null Values 3.7 Groups of Rows in SQL 3.8 A Complete Description of SQL Select Expressions, Predicates, and the Search_Condition A Discussion of the Predicates 3.9 Insert, Update, and Delete Statements The Insert Statement The Update Statement The Delete Statement 3.10 The Power of the Select Statement The Non-Procedural Select Statement The Select Statement 3.11 Object-Orientation in Database Systems Object-Oriented Database Systems Extended Relational Database SystemsChapter 4 Programs to Access a Database 4.1 Introduction to Embedded SQL in C A Simple Program Using Embedded SQL Selecting Multiple Rows with a Cursor 4.2 Error Handling Condition Handling with the Whenever Statement Handling Error Messages Indicator Variables 4.3 Some Common Embedded SQL Statements The Select Statement The Declare Cursor Statement The Delete Statement The Update Statement The Insert Statement Cursor Open, Fetch, and Close Other Embedded SQL Operations 4.4 Programming for Transactions The Concept of a Transaction How Transactions Occur in Programs The Transaction Isolation Guarantee and Locking Special Considerations in Transactions 4.5 The Power of Procedural SQL Programs Customized Set Functions Other Capabilities: Transitive Closure 4.6 Dynamic SQL Execute Immediate Prepare, Execute, and Using Dynamic Select: The Describe Statement and the SQLDA 4.7 Some Advanced Programming Concepts Scrollable Cursors Cursor Sensitivity Fourth-Generation LanguagesChapter 5 Database Design 5.1 Introduction to E-R Concepts Entities, Attributes, and Simple E-R Diagrams Transforming Entities and Attributes to Relations Relationships Among Entities 5.