Database Management System : 2CSE301

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 modelling, designing, and implementing a DBMS.
• Understand Functional Dependency and Functional Decomposition
• Apply various Normalization techniques.
• Perform PL/SQL programming using various basic and advanced concepts of RDBMS.
• Execute various advance SQL queries related to Transaction Processing & Locking using concept of Concurrency control.
• Understand query processing and techniques involved in query optimization.
Syllabus: 
Unit NoTopics
1

Introduction

Introduction and applications of DBMS, Purpose of data base, View of Data, Database Languages, Database architecture, Database users and DBA

2

Relational Model

Structure of Relational Databases, Database Schema, Keys, Relational Operations and Relational Algebra

3

Entity Relationship Model

Basic Concepts and definitions, Constraints, Entity Relationship Diagram, Weak Entity Sets, Extended E-R Features, Conversion of ER diagram into relations

4

SQL

Introduction to SQL, Data Definition of SQL, Basic structure of SQL queries, Basic SQL operations (rename, string operations, order by, where clause), Set operations, Null values, Aggregate functions, Nested Subqueries, Modification of Database, JOIN expressions, Views, Transactions, Integrity constraints, SQL Data types and Schemas, Authorization

5

Relational Database Design

First Normal Form, Decomposition, Desirable Properties of Decomposition, Functional Dependencies, Second and Third Normal Form and Boyce-Cod Normal Form

6

Advanced PL/SQL Concepts

Introduction, Cursors, Stored Procedures, Stored Functions, databaseTriggers

7

Indexing and Hashing

Basic concepts, Ordered Indices, Hash Based Indexing, Tree base Indexing

8

Transaction Management and concurrency

Transaction concepts, properties of transactions, serializability, testing for serializability, Transaction Isolation and Atomicity, Transaction isolation levels, Implementation of isolation levels, Lock based protocols, Deadlock handling, Timestamp based protocols, two- phase locking protocol

9

Query Processing and Query Optimization

Overview, Measures of Query Cost, Transformation of Relational Expressions

Text Books: 
Name : 
Database System Concepts
Author: 
Silberschatz, Korth, Sudarshan,
Name : 
SQL, PL/SQL The Programming Language of ORACLE
Author: 
Ivan Bayross
Reference Books: 
Name: 
An Introduction to Database Systems
Author: 
C. J. Date
Edition: 
7th
Name: 
Database Management Systems
Author: 
by Raghu Ramakrishnan
Johannes Gehrke
Publication: 
McGraw-Hill
Name: 
Basics of Information Management with DB2
Author: 
IBM
Syllabus PDF: 
AttachmentSize
PDF icon DBMS.pdf223.93 KB
branch: 
CBA
BDA
MA
Cyber Security
Course: 
2018
Stream: 
B.Tech