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

4.  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