Database Systems : Concepts, Design & Applications

This book is a comprehensive, practical, and student-friendly textbook addressing fundamental concepts in database design and application. It covers one full semester course on database systems offered to undergraduate (be, b.tech. Bca, b.sc.), postgraduate (me, m.tech., mca, mba, m.sc.), and diploma students of computer science and engineering, information technology, and software engineering. This book also serves as a trainer for various short- and long-term computer courses as well as a reference for practicing engineers and it professionals. About the author: s. K. Singh is head of telecommunication at tata steel limited, jamshedpur. He received degrees in both electrical and electronics engineering, as well as an m.sc. (engg.) in power electronics, from the regional institute of technology (now nit), jamshedpur. He has over 26 years of experience, both academic and professional, in it design, development, and implementation. The author of several books, he has been conferred the eminent engineer and distinguished engineer awards by the institution of engineers for his contributions to the field of computer science and engineering. He is a fellow of the institution of engineers (india). Special features: comprehensive coverage of topics with flexible organization and logical flow. Simple language with real world examples, illustrative figures and exercises. Easy-to-use, step-by-step methodologies for conceptual and logical database designs covering functional dependency, decomposition, normalization, relational algebra, relational calculus, query processing and optimization. Advance and emerging database concepts such as parallel databases, distributed database management, decision support systems, data warehousing and data mining, web-enabled databases, mobile databases, multimedia databases, spatial databases, and digital libraries. Chapters on commercial databases, namely, db2 universal databases, microsoft sql server, oracle, microsoft access and mysql to