Book description
Table of contents
- Cover
- Title Page
- Contents
- Dedication
- Foreword
- Acknowledgements
- Chapter 1. Basics of Database
- Chapter 2. Data Models and Architecture of DBMS
- Chapter 3. Relational Database Management System
-
Chapter 4. Developing Entity-Relationship Diagram
- 4.1 Introduction
- 4.2 Identifying Entities
- 4.3 Identifying Relationships
- 4.4 Types of Relationships
- 4.5 Relationship Participation
- 4.6 Strong and Weak Relationship
- 4.7 Managing Many-to-many Relationship
- 4.8 Example of E-R Model
- 4.9 Extended E-R Model
- 4.10 Converting E-R Model into Relational Model
- 4.11 Object Modelling
- Summary
- Chapter 5. Normalization
-
Chapter 6. Managing Data Using Structured Query Language (SQL)
- 6.1 Introduction
- 6.2 Data Definition Commands
- 6.3 Data Manipulation Commands
- 6.4 SELECT Statement and Its Clauses
- 6.5 Aggregate Functions
- 6.6 Date and Time Functions
- 6.7 String Functions
- 6.8 Conversion Functions
- 6.9 Mathematical Functions
- 6.10 Special Operators
- 6.11 Types of Constraints
- 6.12 Types of Join and Set Operators
- 6.13 Sub-query
- 6.14 Advances SQL Roll-up, Cube, Crosstab
- Summary
- Chapter 7. Introduction to PL/SQL
- Chapter 8. Transaction Management in Database
- Chapter 9. Centralized and Distributed Database Management System
- Chapter 10. Advancement in Databases
-
Chapter 11. Overview of MS-Access 2007
- 11.1 MS-Access as an RDBMS
- 11.2 Elements of MS-Access
- 11.3 Creating Database and Tables
- 11.4 Data Types of MS-Access
- 11.5 Sorting and Filtering Records in MS-Access
- 11.6 Creating Queries in MS-Access
- 11.7 Creating Forms in MS-Access
- 11.8 Creating Reports in MS-Access
- 11.9 Creating Macros and Switchboard
- Summary
- Chapter 12. Overview of Oracle
- References and Bibliography
- Copyright
Product information
- Title: Concepts of Database Management System
- Author(s):
- Release date: April 2013
- Publisher(s): Pearson India
- ISBN: 9789332537422
You might also like
book
Fundamentals of Database Management Systems, Second Edition
Gillenson's new edition of Fundamentals of Database Management Systems provides concise coverage of the fundamental topics …
book
Express Learning: Database Management Systems
Express Learning is a series of books designed as quick reference guides to important undergraduate computer …
book
Introduction to Database Management Systems
Introduction to Database Management Systems is designed specifically for a single semester, namely, the first course …
book
Database Systems: Concepts, Design and Applications
This book is a comprehensive, practical, and student-friendly textbook addressing fundamental concepts in database design and …