Engineering Tutorials

CS– 305 DATABASE MANAGEMENT SYSTEMS

PREREQUISITES: Data Structure

OBJECTIVES : To learn how to use a DBMS and how to build a DBMS.

COURSE CONTENTS:

Part – 1 Basic Concepts

Databases And Database Users: -

Introduction, Characteristics of Database Approach, Advantages And Disadvantages of
Using DBMS. (L-2)

Database System Concepts And Architecture:-

Data Models, Schemas And Instances, DBMS Architecture And Data Independence, Database Language And Interfaces, Classification of Database Management Systems.

(L-3)

Data Modeling Using The Entity Relationship Model:-

Entity Types, Entity Sets, Attributes And Keys, Relationships, Relationship Types, Roles,
And Structural Constrains, Weak Entity Types, ER Diagrams, Naming Conventions And
Design Issues. (L-4)

Part – 2 Relational Model, Language And Systems

The Relational Data Model, Relational Constrains, The Relational Algebra and Relational Calculus:-

Relational Model Concepts, Relational Constraints And Relational Database Schema, Update Operations And Dealing With Constraint Violations, Basic Relational Algebra Operations, Example of Queries in Relational Algebra, The Tupple Relational Calculus, The Domain Relational Calculus. (L-6)

SQL Relational Database Standard:-

Basic queries in SQL, More Complex SQL Queries, Insert, Delete and Update Statements
in SQL, Views in SQL, Additional Features of SQL. (L-6)

Part – 3 Database Design Theory and Methodology

Functional Dependencies and Normalization for Relational Databases:-

Informal Design Guidelines for Relation Schemas, Functional Dependencies, Normal Forms Based on Primary Keys, General Definitions of Second and Third Normal Forms. (L-4)

Part – 4 System Implementation Techniques

Transaction Processing Concepts:-

Introduction to Transaction Processing, Transaction and System Concepts, Desirable Properties of Transactions, Schedules and Recoverability, Serializability of Schedules.

(L-3)

Concurrency Control Techniques:-

Locking Techniques for Concurrency Control, Concurrency Control Based on Timestamp
Ordering, Validation Concurrency Control Techniques, Granularity of Data Items and
Multiple Granularity Locking. (L-3)

Database Recovery Techniques:-

Recovery Concepts, Recovery Techniques Based on Deferred Update,
Techniques Based on Immediate Update, Shadow Paging. (L-4)

Database Security and Authorization:-

Introduction to Database Security Issues, Discretionary Access Control Based on
Granting/Revoking of Privileges, Introduction to Statistical Database Security. (L-

3)

Text Books :

1. Fundamentals of Database Systems, Third Edition, by Elmasri/Navathe

2. Korth and Silberschatz Abraham, Database Concepts, McGraw Hall,1991

3. An introduction to Database Systems by C.J.Date.

References :

1. An introduction to Database Systems by Bipin C. Desai.

SQL,PL/SQL ,The programming language of oracle, Ivan Bayross BPB Publication.

Related posts:

1. MDU Syllabus | F-Scheme | CSE-202 F Database Management Systems
2. CSE-202 E Database Management Systems
3. CSE-434 E Advanced Database Management Systems
4. UPTU Syllabus | ECS-402 : DATA BASE MANAGEMENT SYSTEM
5. PTU Syllabus | CS– 313 Software Lab – V (DATABASE MANAGEMENT SYSTEMS)