Loading... Database Management System | Archana Verma
Database Management System

Click to Enlarge

Book Code: 1111015809930

Archana Verma

All Prices are including Free shipping via Air-Mail

Pages:
ISBN 13:
ISBN 10:
Your Price:

Pages:
ISBN 13:
ISBN 10:
Your Price:

Year:
Language:
Publisher:
Pages:
Book Category:

Untitled Document

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 Protocol
• Granularity of Data Items • Multiversion Schemes.

Appendix — Solutions to Important Questions . 229
• ER diagrams • Relational Algebra • SQL queries • Join Decompositions, Closure , Keys • Conflict serializabity.

Index . 261



Downloads | Privacy Policy |Delivery Policy | Terms & Conditions | Refund & Cancellation

online bookshop for antique books | bookstore for architecture books | buy arts books | online bookshop for biographies books | buy body books | bookstore for business books | shop for children books | bookstore for computer books | shop for cookery books | online bookshop for current events books | shop for customize books | buy dictionaries books | buy economics books | buy encyclopedia books | bookstore for engineering books | online bookshop for english language teaching books | bookstore for environment books | online bookshop for facsimile edition books | bookstore for family books | shop for fiction books | online bookshop for food books | buy geography books | buy hard to find books | buy health books | online bookshop for history books | shop for holiday books | bookstore for humanities books | buy internet books | shop for language books | buy law books | online bookshop for leather binding books | shop for leather edition books | shop for lifestyle books | bookstore for literary studies books | online bookshop for literature books | buy mathematics books | buy medicine books | bookstore for memoirs books | shop for mind books | shop for music books | bookstore for out of print books | online bookshop for parenting books | online bookshop for personal development books | shop for photography books | shop for politics books | bookstore for rare books | bookstore for references books | shop for religion books | bookstore for science books | shop for self help books | buy social sciences books | bookstore for society books | online bookshop for spirit books | online bookshop for spirituality books | shop for sports books | online bookshop for technology books | online bookshop for teens books | buy travel books | buy vintage books | bookstore for wine booksonline bookshop for antique books | bookstore for architecture books | buy arts books | online bookshop for biographies books | buy human body books | bookstore for business books | shop for children books | bookstore for computer books | shop for cookery books | online bookshop for current events books | shop for customize books | buy dictionaries books | buy economics books | buy encyclopedia books | bookstore for engineering books | online bookshop for english language teaching books | bookstore for environment books | online bookshop for facsimile edition books | bookstore for family books | shop for fiction books | online bookshop for food books | buy geography books | buy hard to find books | buy health books | online bookshop for history books | shop for holiday books | bookstore for humanities books | buy internet books | shop for language books | buy law books | online bookshop for leather binding books | shop for leather edition books | shop for lifestyle books | bookstore for literary studies books | online bookshop for literature books | buy mathematics books | buy medicine books | bookstore for memoirs books | shop for mind books | shop for music books | bookstore for out of print books | online bookshop for parenting books | online bookshop for personal development books | shop for photography books | shop for politics books | bookstore for rare books | bookstore for references books | shop for religion books | bookstore for science books | shop for self help books | buy social sciences books | bookstore for society books | online bookshop for spirit books | online bookshop for spirituality books | shop for sports books | online bookshop for technology books | online bookshop for teens books | buy travel books | buy vintage books | bookstore for wine books

Last updated: 18-Jan-2020   Designed by IndiaPRIDE.com