Database Management System (B.Tech)

ER modelling, relational model, SQL, normalisation, transactions and concurrency control.

6 MonthsDuration 5Chapters30Topics

Enquire now

Syllabus · पाठ्यक्रम

Download PDF

01Unit 1: Introduction and ER Model 6 topics

Database system vs file system
DBMS architecture, data models, schema and instances
Data independence, DDL and DML
ER model: entities, attributes, relationships, mapping constraints
Keys: super, candidate, primary
Generalisation, aggregation and reduction of ER diagrams to tables

02Unit 2: Relational Model, Relational Algebra and SQL 6 topics

Relational model and integrity constraints (entity, referential, domain, key)
Relational algebra
Tuple and domain relational calculus
SQL: DDL, DML, operators, sub-queries and aggregate functions
Joins, union, intersect, minus, views and indexes
Cursors, triggers and procedures in PL/SQL

03Unit 3: Database Design and Normalisation 6 topics

Functional dependencies and closure
1NF, 2NF, 3NF and BCNF
Lossless join and dependency preserving decomposition
Multivalued dependencies and 4NF
Join dependencies and 5NF
Alternative approaches to database design

04Unit 4: Transaction Processing and Recovery 6 topics

Transaction concept and ACID properties
Schedules: conflict and view serializability, precedence graph
Recoverable and cascadeless schedules
Log-based recovery and checkpoints
Deadlock handling
Distributed databases: data storage, concurrency control

05Unit 5: Concurrency Control 6 topics

Lock-based protocols and two-phase locking
Timestamp ordering protocol
Validation based protocol
Multiple granularity locking
Multiversion schemes and recovery with concurrent transactions
Case study of Oracle

About

You will be able to

Explain DBMS architecture, data models, schemas and data independence
Draw ER / EER diagrams and reduce them to relational tables
Write relational algebra expressions and SQL queries with joins, sub-queries, views and aggregates
Normalise relations up to BCNF / 4NF using functional and multivalued dependencies
Test schedules for conflict and view serializability and explain log-based recovery
Explain locking, timestamp and validation based concurrency control protocols

Who it is for

B.Tech Computer Science & Engineering, Information Technology students of Semester 5 (AKTU)
Students of other universities studying the same subject who want unit-wise coaching

What you need

Data Structure and Discrete Structures (Semester 3)
Basic programming knowledge

Questions

Which syllabus does the Database Management System course follow?

It follows the AKTU (Dr. A.P.J. Abdul Kalam Technical University, Lucknow) B.Tech syllabus for Database Management System. If your own university's syllabus differs, the centre follows your university syllabus.

Will this help in the university examination?

Yes. Teaching is unit-wise as per the AKTU scheme, with previous-year question practice, MCQ tests and doubt sessions before the semester exam.

Is SQL practice included?

Yes. SQL queries are practised on MySQL / Oracle along with the theory, which also prepares you for the DBMS lab and placement tests.