Database Management System [Hardcover]
Language: English
Published by GenNext Publication, 2018
- Hardcover
- New
Seller: Gyan Books Pvt. Ltd., Delhi, IndiaGyan Books Pvt. Ltd.
AbeBooks seller since March 9, 2011
Condition: New
£ 51.04
- Bank Draft
- Bank Wire Transfer
- Direct Debit
- Invoice
- Money Order
- Paypal
Quantity: Over 20 available
Add to basket
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, EntityRelationship 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 TwoPhase Locking Protocol Strict TwoPhase Locking Protocol Rigorous TwoPhase Locking Protocol Deadlock Free Protocols Graph Based Protocol Timestamp Based Protocol Validation Based Protocol.…
Seller Inventory # 1111015809930
Bibliographic details
- Title
- Database Management System [Hardcover]
- Author
- Archana Verma
- Publisher
- GenNext Publication
- Publication year
- 2018
- Condition
- New
- Binding
- Hardcover
- Language
- English
- ISBN 10
- 9353241332
- ISBN 13
- 9789353241339
Gyan Books Pvt. Ltd.
Delhi, India
AbeBooks seller since March 9, 2011
Shipping rates from India to U.S.A.
| Item | 20 to 25 business days | 15 to 20 business days |
|---|---|---|
| First item | £ 0.00 | £ 18.86 |
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 SCIENCESeller's business information
Gyan Books Pvt Ltd.
5 Ansari Road Daryaganj, New Delhi-110002
Delhi, India 110002
Terms of sale
Our Complete Contact Address
Gyan Books Pvt Ltd.
5 Ansari Road, Daryaganj, New Delhi-110002
amit@gyanbooks.com, Ph. 0091-9899492060
PAN No. AAACG4699N
Authorised Representative Amit Garg
Books listed here are new. All our shipments are through Air Mail only. Extra
shipping may be required in case of multi-volume sets. We can offer Courier
charges of $10/- per kgs to USA and Europe if the ordered quantity of books is
more than 10 kgs. We have special discount for multiple purchase of a single
book. Contact us for special courier/DHL rates. You have the option
of making payment through Visa/Master and Cheques favouring "GYAN BOOKS
PVT.LTD.and payable at US/India are also accepted. We also accept payment
through PAYPAL in favour of "amit@gyanbooks.com". Books are generally shiped
within 0-5 days from the date of order and it takes about 12-20 working days for
delivery to US/UK/Canada/Japan and most other countries. You may return books in
case you receive them in damaged condition. Return books would be replaced
immediately.
Right of withdrawal
If you are a consumer you can withdraw from the contract in accordance with the following. Consumer means any natural person who is acting for purposes which are outside his trade, business, craft or profession.
Information regarding the right of withdrawal
Statutory right to withdraw
You have the right to withdraw from this contract within 14 days without giving any reason.
The withdrawal period will expire after 14 days from the day on which you acquire, or a third party other than the carrier and indicated by you acquires, physical possession of the last good or the last lot or piece.
To exercise the right of withdrawal, electronically fill in and submit a clear statement on our website, under "My Purchases" in "My Account". We will communicate to you an acknowledgement of receipt of such a withdrawal on a durable medium (e.g. by e-mail) without delay.
To meet the withdrawal deadline, it is sufficient for you to send your communication concerning your exercise of the right of withdrawal before the withdrawal period has expired.
Effects of withdrawal
If you withdraw from this contract, we will reimburse to you all payments received from you, including the costs of delivery (except for the supplementary costs arising if you chose a type of delivery other than the least expensive type of standard delivery offered by us).
We may make a deduction from the reimbursement for loss in value of any goods supplied, if the loss is the result of unnecessary handling by you.
We will make the reimbursement without undue delay, and not later than 14 days after the day on which we are informed about your decision to withdraw from this contract.
We will make the reimbursement using the same means of payment as you used for the initial transaction, unless you have expressly agreed otherwise; in any event, you will not incur any fees as a result of such reimbursement.
We may withhold reimbursement until we have received the goods back, or you have supplied evidence of having sent back the goods, whichever is the earliest.
You shall send back the goods or hand them over to Gyan Books Pvt. Ltd., Delhi, India, +91 9899492060, without undue delay and in any event not later than 14 days from the day on which you communicate your withdrawal from this contract to us. The deadline is met if you send back the goods before the period of 14 days has expired. You will have to bear the direct cost of returning the goods. You are only liable for any diminished value of the goods resulting from the handling other than what is necessary to establish the nature, characteristics and functioning of the goods.
Exceptions to the right of withdrawal
The right of withdrawal does not apply to:
- The delivery of newspapers, journals or magazines with the exception of subscription contracts; and
- The supply of digital content which is not supplied on a tangible medium (e.g. on a CD or DVD) if you accepted when you placed your order that we could start to deliver it, and that you could not withdraw once delivery had started.
Shipping terms
Orders usually ship within 2 business days. Shipping costs are based on books weighing 2.2 LB, or 1Kgm. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required. We give extra discount for the bulk purchase orders. Our prices includes shipping charges. The customer do not have to pay any extra charges at the time of delivery but if your Country charges VAT and customs that has to be born by the customer. Time Limit up for discount, we will come with new discount soon.