Database Management System (AD-402) - Official Syllabus

1 min read 0 words

Unit 1

DBMS Concepts and architecture Introduction

Database approach v/s Traditional file accessing approach
Advantages, of database systems
Data models
Schemas and instances
Data independence
Data Base Language and interfaces
Overall Database Structure
Functions of DBA and designer
ER data model: Entitles and attributes
Entity types
Defining the E-R diagram
Concept of Generalization
Aggregation
Specialization
transforming ER diagram into the tables
Various other data models object oriented data Model
Network data model
Relational data model
Comparison between the three types of models

Unit 2

Relational Data models

Domains
Tuples
Attributes
Relations
Characteristics of relations
Keys
Key attributes of relation
Relational database
Schemas
Integrity constraints
Referential integrity
Intension and Extension
Relational Query languages: SQL-DDL
DML
integrity constraints
Complex queries
various joins
indexing
triggers
assertions
Relational algebra and relational calculus
Relational algebra operations like select
Project
Join
Division
outer union
Types of relational calculus i.e. Tuple oriented and domain oriented relational calculus and its operations

Unit 3

Data Base Design

Introduction to normalization
Normal forms
Functional dependency
Decomposition
Dependency preservation and lossless join
problems with null valued and dangling tuples
multivalued dependencies
Query Optimization: Introduction
steps of optimization
various algorithms to implement select
project and join operations of relational algebra
optimization methods: heuristic based
cost estimation based

Unit 4

Transaction Processing Concepts

Transaction System
Testing of Serializability
Serializability of schedules
conflict & view serializable schedule
recoverability
Recovery from transaction failures
Log based recovery
Checkpoints deadlock handling
Concurrency Control Techniques: Concurrency Control
locking Techniques for concurrency control
time stamping protocols for concurrency control
validation based protocol
multiple granularity
Multi version schemes
Recovery with concurrent transaction
Introduction to Distributed databases
data mining
data warehousing
Object Technology and DBMS
Comparative study of OODBMS Vs DBMS
Temporal, Deductive, Multimedia, Web & Mobile database

Unit 5

Study of Relational Database Management Systems through Oracle/PL SQLQL/MySQL

Architecture
physical files
memory structures
background process
Concept of table spaces, segments, extents and block
Dedicated server, multi threaded server
Distributed database, database links, and snapshot
Data dictionary, dynamic performance view
Security, role management, privilege management, profiles, invoker defined security model
SQL queries, Data extraction from single, multiple tables equi- join, non equi-join, self -join, outer join
Usage of like, any, all, exists, in Special operators
Hierarchical quires, inline queries, flashback queries
Introduction of ANSI SQL, anonymous block, nested anonymous block, branching and looping constructs in ANSI SQL
Cursor management: nested and parameterized cursors
Oracle exception handling mechanism
Stored procedures, in, out, in out type parameters, usage of parameters in procedures
User defined functions their limitations
Triggers, mutating errors, instead of triggers
Introduction to NoSql Database

Laboratory Experiments

Delete duplicate row from the table.
Display the alternate row from table.
Delete alternate row from table.
Update multiple rows in using single update statement.
Find the third highest paid and third lowest paid salary.
Display the 3rd, 4th, 9th rows from table.
Display the ename, which is start with j, k, l or m.
Show all employees who were hired the first half of the month.
Display the three record in the first row and two records in the second row and one record in the third row in a single sql statements.
Write a sql statements for rollback commit and save points.
Write a pl/sql for select, insert, update and delete statements.
Write a pl/sql block to delete a record. If delete operation is successful return 1 else return 0.
Display name, hire date of all employees using cursors.
Display details of first 5 highly paid employees using cursors.
Write a database trigger which fires if you try to insert, update, or delete after 7’o’ clock.
Write a data base trigger, which acts just like primary key and does not allow duplicate values.
Create a data base trigger, which performs the action of the on delete cascade.
Write a data base trigger, which should not delete from emp table if the day is Sunday.
Prepare a small database application in complete semester like financial accounting system, Railway reservation system, institute timetable management system, Student record system, library management system, hospital management system etc. in RDBMS: Section A: Solving the case studies using ER data model; Section B: Implement a mini project.

Reference Books

An Introduction To DatabaseSystem — Date C J — Pearson Educations
Fundamental of Database System — Korth, Silbertz, Sudarshan — McGraw Hill
Data Base System:Design Implementation & Management — Rob — Cengage Learninig
Fundamentals Of Database Systems — Elmasri, Navathe — Pearson Educations
Introduction to Database Management System — Atul Kahate — Pearson Educations
Oracle 9i Database Administration Fundamental-I, Volume I — Oracle Press,TMH
DataBase Management System — Paneerselvam — PHI Learning

Go to where you left off?

Quick Add to Notes

Save questions, your own notes and screenshots into notes filed by unit. It takes a free account.

Create free account

Have an account? Log in