Diploma Website   Student Corner   Pay Fees   NIRF

Database Management System (2130703)

Teaching Scheme (in Hours)

Theory Tutorial Practical Total
4 0 4 8

Subject Credit :  8

Examination Scheme (in marks)

Theory
ESE (E)
Theory
PA (M)
Practical
ESE Viva (V)
Practical
PA (I)
Total
0

Syllabus Content    Download

Unit-1:  Introductory concepts of DBMS

Introduction and applications of DBMS, Purpose of data base, Data, Independence, Database System architecture- levels, Mappings, Database, users and DBA

Unit-2:  Relational Model

Structure of relational databases, Domains, Relations, Relational algebra – fundamental operators and syntax, relational algebra queries, tuple relational calculus

Unit-3:  Entity-Relationship model

Basic concepts, Design process, constraints, Keys, Design issues, E-R diagrams, weak entity sets, extended E-R features – generalization, specialization, aggregation, reduction to E-R database schema

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, BCNF, Multi- valued dependency, 4NF, Join dependency and 5NF

Unit-5:  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, materialized views

Unit-6:  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

Unit-7:  Security

Introduction, Discretionary access control, Mandatory Access Control, Data Encryption

Unit-8:  SQL Concepts

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

Unit-9:  PL/SQL Concepts

Cursors, Stored Procedures, Stored Function, Database Triggers

Reference Books

Sr. Title Author Publication Amazon Link
1 An introduction to Database Systems C J Date Wesley
2 Database System Concepts Abraham Silberschatz, Henry F. Korth, S. Sudarshan McGraw Hill
3 Understanding SQL Martin Gruber John Wiley & Sons
4 SQL- PL/SQL Ivan bayross BPB
5 Oracle – The Complete Reference Byrla TMH /oracle press

Course Outcome

After learning the course the students should be able to:

  • Evaluate business information problem and find the requirements of a problem in terms of data.
  • Understand the uses the database schema and need for normalization.
  • Design the database schema with the use of appropriate data types for storage of data in database.
  • Use different types of physical implementation of database.
  • Use database for concurrent use.
  • Backup data from database.

About Us

Darshan Institute of Engineering & Technology is a leading institute offering undergraduate (B.E.), postgraduate (M.E.) and Diploma programs in engineering.

Our Contacts

At Hadala, Rajkot - Morbi Highway,
Gujarat-363650, INDIA

(+91) 97277 47310
(+91) 97277 47311

More contact details