Stock Image

Database Management System

Gagan Varshney

ISBN 10: 8182203201 / ISBN 13: 9788182203204
Published by Global Vision Publishing House, 2010
New Condition: New Soft cover
From BookVistas (New Delhi, DELHI, India)

AbeBooks Seller Since November 24, 2010

Quantity Available: > 20

Buy New
List Price: US$ 23.75
Price: US$ 6.87 Convert Currency
Shipping: US$ 4.69 From India to U.S.A. Destination, Rates & Speeds
Add to basket

30 Day Return Policy

About this Item

In today`s era database is very important. This book provides the introduction about the concepts of database, SQL, Design and their applications. It covers the complete trends in the database technology. This book is useful for Engineers and IT professional. It is very useful to B.Tech, MCA, BCA and other courses students, it covers the complete the syllabus of UP Technical University, Uttrakand Technical University, Punjab Technical University, Rajasthan University, Maharishi Dayanand University, Kurukshetra University, Gujarat University, Karnataka University Salient Features: ? Covers wide range of topics with real word examples and appropriate number of figures. ? Covers important topics like relational algebra, tuple relational calculus, domain relational calculus, normalization SQL in brief. ? Covers exercises, question papers including multiple choice questions with solutions. ? Overcome the gap between theory and practical implementation of database concepts with the help of case studies. Contents Preface (v) Unit 1 Introduction 1 Structure ? Introduction ? Objectives of Unit ? Data and Information ? Database Management System ? File Processing System ? Data Abstraction ? Instance and Schema ? Data Independence ? Database Administrator (DBA) ? DBMS Languages ? DBMS Interfaces ? Database Users ? Data Dictionary ? Overall Database Structure ? Difference between DBMS and RDBMS ? Disadvantages of DBMS ? Summary ? Key Terms ? Questions and Exercises Unit 2 Database Design 15 Structure ? Introduction ? Objectives of Unit ? Entity-Relationship (E-R) Model ? Types of Attributes ? Mapping Constraints ? E-R Diagram Notations ? Existence Dependencies ? Weak Entity Set and Strong Entity Set ? Keys ? Generalization ? Specialization ? Aggregation ? Summary ? Key Terms ? Questions and Exercises Unit 3 Relational Data Model and Languages 32 Structure ? Introduction ? Objectives of Unit ? Concepts of Relational Data Model ? Integrity Constraints ? Domain Constraints ? Entity Integrity Constraints ? Referential Integrity Constraints ? Foreign Key Constraints ? Relational Algebra ? Modification of Information ? Tuple Relational Calculus ? Using this Notation Writes other Queries ? Some More Queries Based on Employee Database ? Domain Relational Calculus ? Structured Query Language (SQL) ? Components of SQL ? Oracle Datatypes ? Basic Domain Types ? Modification of the Database ? Basic Structure of SQL Queries ? Keyword, Clause and Statement ? The Rename Operation ? Tuple Variables ? String Operations ? ?ORDER BY? Clause ? Aggregate Functions ? ?GROUP BY? Clause ? Working with NULL values ? Set Operations ? Nested Subqueries ? Views ? PL/ SQL ? PL/SQL Block Structure ? Data Types ? Variable Declaration ? If- then- else Statement ? CASE Statement ? Looping Structure ? Some Important Questions and their Solutions Based on above Basic Loop Looping Structure ? Nested Loops ? Printing in PL/SQL ? Cursor ? Explicit Cursor Attributes ? Steps to Declare and Use a Cursor ? Implicit Cursor Attributes ? Triggers ? Clusters ? Summary ? Key Terms ? Questions and Exercises Unit 4 Normalization 102 Structure ? Introduction ? Objectives of Unit ? Normalization ? Functional Dependency ? Database Anomalies ? Fully functional Dependent ? Properties of Normalized Relations ? Normal Forms ? Lossless Decomposition ? Closure of a Set of Functional Dependencies ? Closure of Attribute Sets ? Summary ? Key Terms ? Questions and Exercises Unit 5 Transaction Management 126 Structure ? Introduction ? Objectives of Unit ? Transaction Processing Concepts ? Characteristics of Transaction Processing Concepts ? ACID Properties ? Serializability ? Test for Conflict Serializability ? Recoverability ? Recovery from Transaction Failures ? Log-Based Recovery ? Checkpoint ? Summary ? Key Terms ? Questions and Exercises Unit 6 Conc Printed Pages: 326. Bookseller Inventory # 46510

Ask Seller a Question

Bibliographic Details

Title: Database Management System

Publisher: Global Vision Publishing House

Publication Date: 2010

Binding: Softcover

Book Condition:New

About this title

Synopsis:

In today's era databases are very important. This book provides the introduction about the concepts of database, SQL, Design and their applications. It covers the complete trends in the database technology. This book is useful for Engineers and IT professional. It is very useful to B.Tech, MCA, BCA and other courses students, it covers the complete the syllabus of UP Technical University, Uttrakand Technical University, Punjab Technical University, Rajasthan University, Maharishi Dayanand University, Kurukshetra University, Gujarat University, Karnataka University

"About this title" may belong to another edition of this title.

Store Description

Visit Seller's Storefront

Terms of Sale:

All books are new. We accept payments by the following methods:

  1. Credit Card: Visa, MasterCard, or American Express.
  2. PayPal.
  3. Bank Draft or Banker's Cheque.
  4. Bank/Wire Transfer.

Cheques may be made payable to BookVistas.

Books are shipped by DHL, FedEx, Aramex, Registered Air Mail, or Registered SAL (Surface Air
Lifted).


Shipping Terms:

Shipping costs are based on books weighing 2.2 LB, or 1 KG. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required.

List this Seller's Books

Payment Methods
accepted by seller

Visa Mastercard American Express

PayPal Bank Draft Bank/Wire Transfer