Email: tovisionpune@gmail.com
Relational Database Management Systems
Specific References
Relational Database Management Systems
Includes: Database System Concept and Data Modeling, Relational Data Model and Secutiry and Integrity Specification, SQL and PL- SQL, Relational Database Design, Storage and File Systems, Query Processing and Transaction Processing
According to New Revised 'E' Scheme
DOWNLOAD FREE SAMPLE CHAPTER
Contents
1. DATABASE SYSTEM CONCEPT AND DATA MODELING
1.1 Introduction
1.2 Database Users
1.3 Data Models
1.4 Introduction to Client- Server Architecture
2. RELATIONAL DATA MODEL AND SECURITY AND INTEGRITY SPECIFICATION
2.1 Relational Model
2.2 Database Security And Authorization
2.3 Query Language
2.4 Introduction to views
3. SQL and PL- SQL
3.1 Introduction
3.2 PL/SQL Introduction
3.3 Cursor
3.4 package
- RELATIONAL DATABASE DESIGN, STORAGE AND FILE SYSTEMS
4.1 Introduction
4.2 Purpose of Normalization
4.3 E-R Model details
4.4 File Organization
4.5 Basic Concept of Indexing –Order Indices
5. QUERY PROCESSING AND TRANSACTION PROCESSING
5.1 Query processing
5.2 Concept of Transaction Processing
5.3 lock granularity
5.4 Deadlocks