Fundamentals of Database Management Systems

Database Management is all about storage, modification and retrieval of information from a database and is an important subject of study for both students and professionals. This book in 37 chapters covers the fundamentals of database management and is intended for students, teachers, and professional alike.

Author(s): Alexis Leon

Unit I – Introduction and Conceptual Modeling
1. Introduction to Database Management Systems (DBMS)
2. Database Architecture and Design
3. Data Models
4. Entity-Relationship (E-R) Modeling
5. Enhanced Entity-Relationship (EER) Model
Unit II – Relational Database Management
6. Relational Database Management Systems (RDBMS)
7. Relational Data Integrity and Database Constraints
8. Transforming ER Models to Relations
9. Data Normalization
10. Relational Algebra
11. Relational Calculus
Unit III – Structured Query language
12. Structured Query Language
13. Nulls
14. Tables Used in this Book
15. Tables, Views, and Indexes
16. Queries and Sub queries
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 VII – Knowledge Discovery
35. Knowledge Discovery in Databases
36. Data Warehouses and Data Marts
37. Data Mining and On-Line Analytical Processing (OLAP)

No records found
ISBN : 9788182090293
Price : 350.00
Choose Quantity :
  • Published: 24 April 2010
  • Edition: 1
  • ISBN: 9788182090293
  • Availability: In Stock
  • Pages: 628

Also Recommended