2CSE403 Database Management System

Credit Hour Table

Lecture Hour T/W Hour Practical Hour Total Hour Lecture Credit T/W credit Practical Credit Total Credit
3 0 2 5 3 0 1 4
3 2 5 3 0 1 4
3 0 4 7 3 0 2 5

Examination Scheme

Theory Int. Asses. Theory Sem End Theory Hours Theory Total Practical / TW Asses. Grand Total
20 30 0 50 100 150
40 60 3 100 50 150
40 60 3 100 50 150
Learning Outcomes: 
Understand database concepts and structures and query language
Understand the E R model and relational model
To design and build a simple database system and demonstrate competence with the fundamental tasks involved with modeling, designing, and implementing a DBMS.
Understand Functional Dependency and Functional Decomposition.
Apply various Normalization techniques
Perform PL/SQL programming using concept of Cursor Management, Error Handling, Package and Triggers
Execute various advance SQL queries related to Transaction Processing & Locking using concept of Concurrency control.
Understand query processing and techniques involved in query optimization.
Understand the principles of storage structure and recovery management.
Syllabus: 
Unit NoTopics
1
Introduction
Introduction and applications of DBMS, Purpose of data base, Data, Independence, Database System architecture- levels, Mappings, Database, users and DBA.
2
Entity Relationship Model
Basic Concepts , Constraints, Keys , Design Issues , Entity Relationship Diagram, Weak Entity Sets, Extended E-R Features , Design of an E-R Database Schema Reduction of an E-R Schema to Tables.
3
Relational Model
Structure of Relational Databases, The Relational Algebra, Extended Relational Algebra Operations, Modifications of the Database Views, The Tuple Relational Calculus , The Domain Relational Calculus.
4
SQL
Basics of SQL, DDL,DML,DCL, structure – creation, alteration, defining constraints – Primary key, foreign key, unique, not null, check, IN operator, Functions - aggregate functions, Built-in functions – numeric, date, string functions, set operations, sub-queries, correlated sub-queries, Use of group by, having, order by, join and its types, Exist, Any, All , view and its types. transaction control commands – Commit, Rollback, Savepoint.
5
Relational Database Design
First Normal Form, Pitfall of Relational-Database Condition, Functional Dependencies, Decomposition, Desirable Properties of Decomposition, Boyce-Codd Normal Form Third Normal Form.
6
PL/SQL Concepts
Introduction, Cursors, Stored Procedures, Stored Functions, database Triggers.
7
Overview of Storage and Indexing
Data on External Storage – File Organization and Indexing – Cluster Indexes, Primary and Secondary Indexes – Index data Structures – Hash Based Indexing – Tree base Indexing.
8
Transaction Management
Transaction concepts, properties of transactions, serializability of transactions, testing for serializability, System recovery, Two- Phase Commit protocol, Recovery and Atomicity, Log-based recovery, concurrent executions of transactions and related problems, Locking mechanism, solution to concurrency related problems, deadlock, , two-phase locking protocol, Isolation, Intent locking.
9
Security
Introduction, Discretionary access control, Mandatory Access Control, Data Encryption.
10
Query Processing and Query Optimization
Overview, Measures of Query Cost
11
Database System Architecture
Centralized  and  Client-Server  Architectures,  Server  System  Architectures,  Parallel  Systems,
Distributed Systems
12
Case Study of DB2 Vs Oracle
Reference Books: 
Name: 
Database System Concepts
Author: 
Silberschatz, Korth
Sudarshan
Edition: 
4th
Name: 
An Introduction to Database Systems
Author: 
C. J. Date
Edition: 
7th
Name: 
SQI, PI/SQL The Programing Language of ORACLE
Author: 
Ivan Bayross
Edition: 
2nd
Name: 
Basics of Information Management with DB2
Author: 
IBM
Name: 
Database Management Systems
Author: 
Raghu Ramakrishnan
Johannes Gehrke
Publication: 
McGraw-Hill
Syllabus PDF: 
AttachmentSize
PDF icon DBMS.pdf162.14 KB
branch: 
CBA
BDA
MA
Course: 
2014
Stream: 
B.Tech