Database systems : models, languages, design, and application programming / Ramez Elmasri & Shamkant B. Navathe.

Chapter one : Introduction to database
1.1 Introduction
1.2 An example
1.3 Characteristics of the data base approach
1.4 Actors on the scene
1.5 Workers behind the scene
etc

Chapter two : Overview of database languages and architectures
2.1 Data models, schemas and instances
2.2 Three schema architecture and data independence
2.3 Database language and interface
2.4 The databases system environment
etc

Chapter three : The basic (flat ) relational model
3.1 Relational model concepts
3.2 Relational model constraints and relational database schema
3.3 update operations, transactions and dealing with constraints violation
etc.

Chapter four : SQL; Data definitions, constraints and the basics, queries and updates
4.1 SQL data definition and data types
4.2 Specifying constraints
4.3 Basic retrieval queries in SQL
4.4 INSERT, DELETE and UPDATE Statements in SQL
etc

Chapter five : SQL: Advanced queries, assertions, triggers and views
5.1 More complex SQL retrieval queries
5.2 Specifying constraints as assertion and action as triggers
5.4 Schema change statement
5.5 summary
etc

Chapter six : Formal relational language : The algebra and calculus
6.6 Unary relational operations ; SELECT and PROJECT
6.2 Relational algebra operation from set theory
6.3 Binary relational operation JOIN and DIVISION
6.4 Additional relational operations
6.5 The tuple relational calculus
etc

Chapter seven : Conceptual data modelling using entities and relationships
7.Using high level conceptual data models for database deign
7.2 A sample database application
7.3 Entity types, entity sets, attributes and keys
7.4 Relationship types, relationship sets, roles and structural constraints
etc

Chapter 8 : Mapping a conceptual design into a logical design
8.1 Relational database design using ER to relational mapping
8.2 Mapping EER model constraints to relations
8.3 Summary

Chapter 9 : UML for database application design
9.1 Basic of UML class diagrams
9.2 Representing specialisation and generalisation in UML class diagram
9.3 Use of UML diagram as an aid to database
etc

Chapter ten : Object and object relational database : concepts, models, languages and standards
10.1 Overview of object database concepts
10.2 Object relational features ; object database extentions
10.3 The ODMG object model and the object definition
etc

Chapter 11 : XML : languages and standards
11.1 Structured, semi structured and unstructured data
11.2 XML hierarchical data model
11.3 XML document, DTD, and XML schema
etc

Chapter twelve : SQL application programming using c and java
12.1 Database programming : techniques and issues
12.2 Embedded
SQL, dynamic SQL and SQL1
12.3 Database programming with function calls : SQL/CLI and JDBC
ETC

Chapter 13 : SQL web programming usin C PHP
13.1 A simple PHP example
13.2 Overview of Basic features of PHP
13.3 Overview of PHP database programming

Chapter fourteen : Database design theory : Introduction to normalisation using functional and multivalued dependence
14.1 Informal design guidnlines for relational schema
14.2 Functional dependence
14.3 Normal forms based on primary keys
etc

Chapter fifteen : Database design theory : normalisation
15.1 Further topics in functional dependencies : inference rules, equivalent and minimal cover
15.2 Properties of relational decompositions
15.3 Algorithms for relational database schema
etc

Chapter Sixteen : Database file organisation : Unordered, ordered and hashed file of records
16.1 Introduction
16.2 Secondary storage devices
16.3 Buffering o0f blocks
etc

Chapter seventeen : Database file indexing techniques , b-Tress and B tress
17.1 Types od single level ordered indexes
17.2 Multilevel indexes
17'3 Dynamic multilevel indexes using B-tress
etc

Chapter 18 : Introduction to query processing and query optimisation technigues
18.1 Translating SQL query into relational algebra
18.2 Algorithms for external sorting
18.3 Algorithms for SELECT and JOIN operation
etc

Chapter nineteen : Introduction to database turning and physical design issues
19.1 Physican database design in relational database
19.2 An overview of database turning in relational systems
19.3 Summary
etc

Chapter 20 : Foundation of database transaction processing
20.1 Introduction to transaction processing
20.2 Transaction and system concepts
20.3 Desirable properties of transactions
etc.

Chapter Twenty one : Introduction to protocols of concurrency control in database
21.1 Two phase locking techniques for concurrency control
21.2 concurrency control based on time stamp ordering
21.3 multiversion concurrency control techniques
etc...

Chapter Twenty two Introduction to database recovery protocols
22.1 Recovery concepts
22.2 No undo /redo recovery based on deferred updates
22.3 Recovery techniques based on immediate updates
22.4 shadow paging
etc...

Chapter twenty three
23.1 Mobile data management
23.2 Multimedia data management
23.3 geographic information systems (GIS)
etc.

Chapter twenty four : Advanced database models and applications
24.1 Active database concepts and triggers
24.2 Temporal database concepts
24.3 Spatial database concepts
etc.

Chapter twenty five : Introduction to database security
25.1 Introduction to database security issues
25.2 Discretionary access control based on granting
25.3 Discretionary access control and role-based access control for multilevel security
etc.

Chapter twenty six : Introduction to distributed databases
26.1 Distributed database concepts
26.2 Types of distributed database systems
26.3 Distributed database architecture
etc.

Chapter twenty seven : introduction to database retrieval
27.1 Information retrieval concepts
27.2 Retrieval models
27.3 Types of queries in IR systems
etc.

Bibliography : p.1081-1114 . _ Index : p. 1115-1155