TY - BOOK AU - Elmasri,Ramez AU - Navathe,Sham TI - Fundamentals of database systems SN - 9781292097619 AV - QA76.9.F8 E57 2017 PY - 2017/// CY - Boston PB - Pearson Education Limited KW - Database management N1 - Includes bibliographical references and index; Database and database users -- Database system concepts and architecture -- The relational data model and relational database constraints -- Basic SQL -- More SQL : Complex queries, triggers, views and schema modification -- The relational algebra and relational calculus -- Data modelling using the entity relationship model -- The enhanced entity relationship model -- Relational database design by ER- and EER-to-Relational mapping -- Practical database design methodology ad use of UML diagrams -- Object and object relational databases -- XML : Extensible markup language -- Introduction to SQL programming techniques -- Web database programming using PHP -- Basic of functional dependencies and normalization for relational databases -- Relational databases design algorithm and further dependencies -- Disk storage, basic file structure and hashing -- Indexing structures fir files -- Algorithm for query processing and optimization -- Physical database design and tuning -- Introduction to transactions processing concepts and theory -- Concurrency control techniques -- Database recovery techniques -- Database security -- Distributed databases -- Enhanced data models for advanced applications -- Introduction to information retrieval and web search -- Overview of data warehousing and OLAP ER -