Rashtrasant Tukadoji Maharaj Nagpur University, Maharashtra, Computer Engineering Semester 4, Database Management System Syllabus

Database Management System Lecture notes | Videos | Free pdf Download | Previous years solved question papers | MCQs | Question Banks| Syllabus
Get access to 100s of MCQs, Question banks, notes and videos as per your syllabus.
Try Now for free

Unit - 1 Introduction to database systems

Unit – 1

Introduction to database systems

1.1 Introduction to database systems Approaches to building a database

1.2 Threeschema architecture of a database

1.3 Challenges in building a DBMS

1.4 DBMS Architecture Various components of a DBMS

1.5 Types of data models

Unit - 2 Relational Data Model

Unit 2

Relational Data Model

2.1 Relational Data Model Concept of relations

2.2 Schemainstance distinction

2.3 Keys

2.4 Referential integrity and foreign keys

2.5 Relational algebra operators

2.6 Tuple relation calculus

2.7 Domain relational calculus

2.8 Physical and logical hierarchy Concept of index

2.9 Btrees

2.10 Hash index

2.11 Function index

2.12 Bitmap index

2.13 Concepts of Functional dependency

2.14 Normalization 1NF2NF3NF BCNF etc.

Unit - 3 Query Processing and Optimization

Unit 3

Query processing and optimization

3.1 Query process and optimization process

3.2 Measures of query cost estimation in query optimization

3.3 Pipelining and materialization

3.4 Structure of query evaluation plan

Unit - 4 Transactions

Unit 4

Transactions

4.1 Transaction concepts

4.2 Properties of transactions

4.3 Serializability of transactions

4.4 Testing for serializability

4.5 System recovery

4.6 TwoPhase Commit protocol

4.7 Recovery and Atomicity

4.8 Log based recovery

4.9 Concurrent executions of transactions

4.10 Locking mechanism

4.11 Solution to concurrency related problems

4.12 Deadlock

4.13 Twophase locking protocol

4.14 Isolation

Unit - 5 Recovery System and advanced databases

Unit 5

Recovery System and advanced databases

5.1 Failure classification

5.2 Recovery and atomicity

5.3 Log based recovery

5.4 Checkpoints

5.5 Buffer management

5.6 Advanced recovery techniques

5.7 Web databases

5.8 Distributed databases

5.9 Data warehousing

5.10 Data mining

5.11 Data Security

5.12 NOSQL databases

Download CSE Sem 4 syllabus pdf
Get access to 100s of MCQs, Question banks, notes and videos as per your syllabus.
Try Now for free
Other Subjects of Semester-2
Computer network
System programming
Theory of computation
Data structures and program design
Discrete mathematics and graph theory
Popular posts
Top 10 free online resources to learn coding
What is machine learning
What is cloud computing
What is DBMS architecture
Sorting algorithm overview
Share  
Link Copied
More than 1 Million students use Goseeko! Join them to feel the power of smart learning.
Spot anything incorrect? Contact us