Database Environment: Basic Concepts, Advantages of Database approach, Comparison with
Traditional file systems, DBMS Architecture, Database Users, Data Models and Schemas, Database
languages and Interfaces; Database development process: Development Lifecycle, Types of
Application.
Introduction to Data Modeling, Modeling the rules, Entity Relationship Model, ER Model
Constructs‐ Attributes, Relationship etc., Enhanced ER Model and Business Rules, Modeling
Introduction to SQL – Inserting , Updating, and Deleting data, Processing Single Tables, Processing
Multiple Tables, PL/SQL Constructs ‐ Views, Triggers, Cursors etc; Transaction Processing –
Properties, Schedules and Serializability Issues. Concurrency Control – Introduction, Locking and
Time Stamping Issues etc.
