|Publishers||R. Narain & Co.|
|Subject||Data Base Management System|
Data Base Management System (IT03)
This book is designed to meet the needs of master of business administration students studying for the very first time in their curriculum. Thus complexity of the matter has been avoided with a view that complete course content has to be completed by the student in limited time period. The subject matter has been presented in a lucid, comprehensive and systematic manner which is easy to understand and also develops writing ability for students to score good marks in upcoming examination. This book includes all types of questions according to new pattern of university. Course content has been divided into topic wise and in chapter wise form according to curriculum framed by Dr. A.P.J. Abdul Kalam Technical University, Lucknow. This book includes unsolved papers of last years and sample paper. We hope that this book will be successful in its objectives and will receive appreciation from students and teachers alike.
Estimated Delivery for Urban Areas 3 to 4 Days
Estimated Delivery for Rural Areas 5 to 7 Days
Table of Content
Unit-I: Introduction: Overview, database system Vs file system, Database system concept and architecture, data model schema and instances, data independence and database language and interfaces, data definitions language, DML, Overall Database Structure. Data modeling using the Entity Relationship Model: ER model concepts, notation for ER diagram, mapping constraints,
Unit-II: Relational data Model and Language: keys, Concepts of Super Key, candidate key, primary key, Relational data model concepts, integrity constraints, entity integrity, referential integrity, Keys constraints, Domain constraints, relational algebra, relational calculus, and tuple and domain calculus.
Unit-III: Introduction on SQL: Characteristics of SQL, advantage of SQL. SQL data type and literals. Types of SQL commands. SQL operators and their procedure. Tables, views and indexes. Queries and sub queries. Aggregate functions. Insert, update and delete operations, Joins, Unions, Intersection, Minus, Cursors, Triggers, and Procedures in SQL/PL SQL
Data Base Design & Normalization: Functional dependencies, normal forms, first, second, third normal forms.
Unit-IV: Transaction Processing Concept: Transaction system, Testing of serializability, serializability of schedules, conflict & view serializable schedule, recoverability, backup, Recovery from transaction failures, log based recovery, checkpoints, deadlock handling.
Concurrency control, Locking Techniques for concurrency control, Time stamping protocols for concurrency control, validation based protocol, multiple granularity, Multi version schemes,
Unit-V: Recent Trends in Database Management Systems: Centralized and Client-Server Architectures, Distributed Databases, Object-Oriented Database, Spatial & Temporal Databases, Decision Support Systems, Data Analysis, Data Mining & Warehousing, Data Visualization, Mobile Databases, OODB & XML Databases, Multimedia & Web Databases, Spatial and Geographical Databases, Web and Mobile Databases, Active Databases
Salient features include:
- Comprehensive coverage of theoretical aspects in management concept & Indian ethos.
- All intricate aspects are explained by simple, lucid and specific explanations and substantiated with neat and elaborate diagrammatic sketches.