Fundamentals of database systems /
Ramez Elmasri and Shamkant B. Navathe.
- 5th ed.
- Boston : Pearson Addison Wesley, c2007.
- xxviii, 1139 p. : ill. ; 24 cm.
Includes bibliographical references (p. 1067-1095) and index.
Databases and database users -- Database system concepts and architecture -- Data modeling using the entity-relationship (ER) model -- The enhanced entity-relationship (EER) model -- The relational data model and relational database constraints -- The relational algebra and relational calculus -- Relational database design by ER- and EER-to-relational mapping -- SQL-99 : schema definition, constraints, queries, and views -- Introduction to SQL programming techniques -- Functional dependencies and normalization for relational databases -- Relational database design algorithms and further dependencies -- Practical database design methodology and use of UML diagrams -- Disk storage, basic file structures, and hashing -- Indexing structures for files -- Algorithms for query processing and optimization -- Physical database design and tuning -- Introduction to transaction processing concepts and theory -- Concurrency control techniques -- Database recovery techniques -- Concepts for object databases -- Object database standards, languages, and design -- Object-relational and extended-relational systems -- Database security -- Enhanced data models for advanced applications -- Distributed databases and client-server architectures -- Web database programming using PHP -- XML : extensible markup language -- Data mining concepts -- Overview of data warehousing and OLAP -- Emerging database technologies and applications -- Alternative diagrammatic notations for ER models -- Parameters of disks -- Overview of the QBE language. 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. App. A. App. B. App. C.