Skip to content
CampusPrep
IT-405 · Data Base Management System/Official Syllabus

Data Base Management System (IT-405) - Official Syllabus

1
Unit 1

Basic Concepts

  • Introduction to DBMS
  • File system vs DBMS
  • Advantages of database systems
  • Database System architecture
  • Data models
  • Schemas and instances
  • Data independence
  • Functions of DBA and designer
  • Entities and attributes
  • Entity types
  • Key attributes
  • Relationships
  • Defining the E-R diagram of database
2
Unit 2

Relational Model

  • Structure of relational databases
  • Domains
  • Relations
  • Relational algebra – fundamental operators and syntax
  • relational algebra queries
  • Entity-Relationship model :Basic concepts
  • Design process
  • constraints
  • Keys
  • Design issues
  • E-R diagrams
  • weak entity sets
  • extended E-R features –generalization, specialization and aggregation
3
Unit 3

SQL and Query Optimization

  • Data definition in SQL
  • update statements and views in SQL: Data storage and definitions
  • Data retrieval queries and update statements
  • Query Processing & Query Optimization: Overview
  • measures of query cost
  • selection operation
  • sorting
  • join
  • evaluation of expressions
  • transformation of relational expressions
  • estimating statistics of expression results
  • evaluation plans
  • Case Study of ORACLE and DB2
4
Unit 4

Relational Database design

  • Functional Dependency –definition
  • trivial and non-trivial FD
  • closure of FD set
  • closure of attributes
  • irreducible set of FD
  • Normalization –1NF, 2NF, 3NF
  • Decomposition using FD-dependency preservation
  • lossless join
  • BCNF
  • Multi-valued dependency
  • 4NF
  • Join dependency and 5NF
5
Unit 5

Transaction, Concurrency Control and Advanced Topics

  • Introduction of transaction
  • transaction processing and recovery
  • Concurrency control: Lock management
  • specialized locking techniques
  • concurrency control without locking
  • Protection and Security
  • Introduction to: Distributed databases
  • Basic concepts of object oriented data base system

Laboratory Experiments

  • To perform various SQL Commands of DDL, DML, DCL.
  • Write SQL Commands such as Insertion, deletion and updation for any schema.
  • To execute Nested Queries, Join Queries, order-by, having clause and string operation.
  • To perform set operators like Union, Intersect, Minus on a set of tables.
  • To execute various commands for GROUP functions (avg, count, max, min, Sum).
  • Write a PL/SQL block for transaction application using Triggers.
  • Write a DBMS program to prepare report for an application using function.
  • Designing of various Input screens/Forms.
  • Create reports using database connectivity of Front end with back end.
  • Create database Design with normalization and implementing in any application.

Reference Books

  • Database Concepts — Korth, Silbertz, Sudarshan — McGraw Hill
  • Fundamentals of Database Systems — Elmasri, Navathe — Pearson
  • SQL, PL/SQL the Programming Language of Oracle — Ivan Bayross — BPB publications
  • Advanced Database Management System — S. Sharma, J. Agrawal, S. Agrawal — Dreamtech Press
  • Fundamental of Data Base Management System — Leon & Leon — TMH
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