The Complete Text Book for BCA, B.E., B.Sc.(IT), MCA, MSC(IT) DOEACC 'A7' paper and other I.T. Related Examinations of the Leading Universities.This book presents a detailed discussion on Relational database and Traditional database models in easy-to-understand language.Concepts of DBMS architecture, administration and database design discussed in such a manner that students of all streams can understand this subject very easily.Properties of relational model, concept of keys, integrity rules and stand-alone query languages are portrayed in a very comprehensive manner to build a strong foundation in relational database system.Structure Query language (SQL), Embedded SQL, relational algebra, tuple relational calculus and domain relational calculus are explained with maximum number of examples as well as with simple and complex specimen queries.A special characteristic of the book is that solved test paper is included at the end of each Chapter. Readers can evaluate their progress easily by solving these questions and comparing with the given answers.Special Features of the book are:Use of Embedded SQL and PL/SQL in application development, handling of cursors, use of API's, database connectivity through ODBC explained in detail so that the readers will be able to develop database applications comfortably.Data definition, manipulation and control through SQL are explained using befitting examples.Fundamentals of database design, covering topics like Entity Relationship diagram, Normalization, Aggregation, functional dependencies, clustering indexing, etc. are explained in a simple manner.Advanced DBMS concepts including transaction processing, security, concurrency control, database recovery and query processing are described in such a manner that even a layman could digest these advanced topics.A set of Appendices are added giving sufficient insight into form design, report design, data validation,trouble-shooting and documentation. Consequently, the book would also serve as a guidebook for developing DOEACC 'A' Level Project.Comprehensive glossary and index are included for easy access to numerous terms needed for understanding the subject matter and for answering the objective questions.
