Home >> Database Systems >> Fundamentals of Database Management Systems >> Table of Contents

Unit I – Introduction and Conceptual Modeling

01. Introduction to Database Management Systems (DBMS)
02. Database Architecture and Design
03. Data Models
04. Entity-Relationship (E-R) Modeling
05. Enhanced Entity-Relationship (EER) Model

Unit II - Relational Database Management

06. Relational Database Management Systems (RDBMS)
07. Relational Data Integrity and Database Constraints
08. Transforming ER Models to Relations
09. Data Normalization
10. Relational Algebra
11. Relational Calculus

Unit III - Structured Query Language (SQL)

12. Structured Query Language (SQL)
13. Nulls
14. Tables Used in this Book
15. Tables, Views, and Indexes
16. Queries and Subqueries
17. Aggregate Functions
18. INSERT, UPDATE, and DELETE Operations
19. Cursors
20. Joins and Unions
21. Programming with SQL
22. Triggers

Unit IV - Data Storage and Query Processing

23. Secondary (Auxiliary) Storage Devices
24. Files, File Organization, and File Structures
25. Indexing and Hashing
26. Query Processing and Query Optimization

Unit V - Database Implementation Issues

27. Database Security
28. Data Integrity
29. Transaction Management and Concurrency Control
30. Backup and Recovery

Unit VI - Modern Databases

31. Introduction to Modern Databases
32. Distributed Databases
33. Object-oriented and Object-relational Databases
34. XML

Unit VI - Knowledge Discovery

35. Knowledge Discovery in Databases (KDD)
36. Data Warehouses and Data Marts
37. Data Mining and On-line Analytical Processing (OLAP)

Unit VII - Appendix

Appendix A. Model Question Papers

Index

Home| Software Engineering| Database Systems| Information Technology| Internet & WWW| Computers| Miscellaneous
Copyright ©  2005 Leon-Leon.com. All rights reserved.