Database Management System

Language: English

Published by GenNext Publication, 2020

9353242339 / 9789353242336

  • Softcover
  • New
See all details
Item image 1 of 2.

Seller: Gyan Books Pvt. Ltd., Delhi, IndiaGyan Books Pvt. Ltd.

5-star seller

AbeBooks seller since March 9, 2011

View this seller's items
Softcover

Condition: New

£ 39.80

 Free Shipping 
Ships from India to U.S.A.
Seller accepted payment methods
  • Bank Draft
  • Bank Wire Transfer
  • Direct Debit
  • Invoice
  • Money Order
  • Paypal

Quantity: Over 20 available

Add to basket
Free 30-day returns
Want to pay with your credit card?
  • Visa
  • Mastercard
  • American Express
  • Apple Pay
  • Google Pay
Buy on AbeBooks.com

Item description from seller

Language: English. ABOUT THE BOOK:- Database Management Systems is a core subject which explains how data is managed for applications which are used in our day to day life such as Banking Systems, Railway Reservation Systems etc. The book DATABASE MANAGEMENT SYSTEMS has been written for B.Tech 3rd year students of Dr. A.P.J. Abdul Kalam Technical University. The book has been written according to the syllabus of the subject Database Management Systems and concepts have been explained well through the help of examples and diagrams. The book contains Introduction, Entity-Relationship Model, Relational Algebra, SQL, Functional Dependencies and Normalization, Distributed Databases, Transaction Processing and Concurrency Control. ABOUT THE AUTHOR:- Archana Verma is an Associate Professor in the Department of CSE / IT / MCA in IEC Group of Institutions, Greater Noida, affiliated to Dr. A.P.J. Abdul Kalam Technical University, Lucknow. She has taught B.Tech, M.Tech and MCA students for last 16 years. She worked with TCS for 6 years prior to that. She obtained Master of Information Science Degree in June 1995 from University of New South Wales, Canberra, Australia. MCA from Maharishi Dayanand University, Rohtak in June 2004 and M.Tech (Computer Science Engineering) from Amity University, Noida in June 2013. She has written two books, "Unix and Shell Programming" and "Bioinformatics". She is a dedicated teacher and loves her profession. She likes to share her knowledge with students through writing books. CONTENTS:- Acknowledgement . 9 Synopsis . 11 1. Introduction . 13• An Overview of Database Management System • Users in a Database System • Database Systems vs File systems • Categories of Data Models • The 3 Schema Architecture • Data Independence • Data Base Languages and Interfaces • DataBase Structure. 2. Entity Relationship Model . 29 • Definitions • Entity Types, Entity Sets and Value Sets • Keys • Relationships, Relationship Types, Relationship Instance, Relationship Sets, Relationship Degree • Constraints on Relationship Types • The ER Diagram • Reducing the ER Diagram into Tables • Weak Entity Type • Ternary Relationships • Subclasses and Superclasses • Aggregation. 3. Relational Model and Relational Algebra . 63 • Introduction • Domains, Attributes, Tuples and Relations • Relational Constraints and Relational database Schemas • Relational Algebra Operations • Operations Particularly Designed for the Relational Database • The Division Operation • Aggregate Functions • The Tuple Relational Calculus • The Domain Relational Calculus. 4. Structured Query Language (SQL) . 91• Structured Query Language Definition • Basic Structure of SQL Queries • Complex and Nested Queries • Set Operations • Aggregate Functions • NULL Values • Modification of the Database • Join Expressions • Views • Accessing SQL from a Programming Language • Functions and Procedures. 5. Functional Dependencies and Normalization . 123• Introduction • Updation Anomalies • Functional Dependencies • NORMAL FORMS • Multivalued Dependencies and Fourth Normal Form • Join Dependency and Fifth Normal Form • Lossless Join Decomposition • Dependency Preservation Property of a Decomposition • Inclusion Dependencies. 6. Transaction Processing . 165 • Introduction • Transaction Concept • Transaction States • Problems that Occur during Concurrency • Schedules and Recoverability • Schedules and Serializability • Conflict Serializability • Testing for Conflict Serializability • View Serializability • Transaction Support in SQL • Recovery Techniques • Caching • Database Backup. 7. Distributed Databases . 197 • Distributed Data Storage • Concurrency Control • Directory System. 8. Concurrency Control . 205• Concurrency Control • Guaranteeing Serializability with the help of Locks • The Two-Phase Locking Protocol • Strict Two-Phase Locking Protocol • Rigorous Two-Phase Locking Protocol • Deadlock Free Protocols • Graph Based Protocol • Timestamp Based Protocol • Validation Based Pro.

Seller Inventory # PB1111015809930

Bibliographic details

Title
Database Management System
Author
Archana Verma
Publisher
GenNext Publication
Publication year
2020
Condition
New
Binding
Paperback
Language
English
ISBN 10
9353242339
ISBN 13
9789353242336

Gyan Books Pvt. Ltd.

Delhi, India

5-star seller

AbeBooks seller since March 9, 2011

Shipping rates from India to U.S.A.

Item20 to 25 business days15 to 20 business days
First item£ 0.00£ 18.90
Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.

Payment methods

You can pay with your credit card on AbeBooks.com.
  • Bank Draft
  • Bank Wire Transfer
  • Direct Debit
  • Invoice
  • Money Order
  • Paypal

Store description

We are located in the heart of Indian book Industry with three floors having all the infrastructure required for book shop. We are dealing in almost all books published from India, if some one does not find any book on any website or store, please let us know. We also provide the customized books published as per the requirement of the customer.

Specialty

ANTHROPOLOGY, ART, SOCIOLOGY, DICTIONARIES, EDUCATION, REFERENCE, WOMEN STUDIES, HISTORY, HUMAN RIGHTS, POLITICAL SCIENCE

Seller's business information

Gyan Books Pvt Ltd.

5 Ansari Road Daryaganj, New Delhi-110002
Delhi, India 110002