Study material
Engineering
Computer Engineering
Information Technology
Electrical Engineering
Civil Engineering
Mechanical Engineering
Electronics and Communications
Electronics and Telecommunication
Electrical and Electronics
B.Com
B.A
BBA
BAF
BMS
New Test BE-Btech
Demo BE-Btech
Prod BE-BTech
Blog
Log in
Become a world-class Digital Marketer in the next 3 months.
Join
SkillCamper's
Digital Marketing Bootcamp.
Get guaranteed job placement and a minimum
salary of Rs 5 lakhs.
Explore Now
Rashtrasant Tukadoji Maharaj Nagpur University, Maharashtra, Artificial Intelligence 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 General Introduction To Database Systems
Unit – 1
General introduction to database systems
1.1 General introduction to database systems Approaches to building a database
1.2 DatabaseDBMS distinction
1.3 Data models
1.4 Threeschema architecture of a database
1.5 Various components of a DBMS
1.6 Data Abstraction
1.7 Data Independence
1.8 ER Data model
1.9 SQL Concept
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
Unit - 3 Physical And Logical Hierarchy
Unit 3
Physical and logical hierarchy
3.1 Physical and logical hierarchy Concept of index
3.2 Btrees
3.3 Concepts of Functional dependency
3.4 Normalization
3.5 Business data analysis
Unit - 4 Overview
Unit 4
Overview
4.1 Query process and optimization
4.2 Measures of query cost estimation in query optimization
4.3 Structure of query evaluation plan
Unit - 5 Transaction concepts
Unit 5
Transaction concepts
5.1 Transaction concepts
5.2 Properties of transactions
5.3 Serializability of transactions
5.4 Testing for serializability
5.5 System recovery
5.6 TwoPhase Commit protocol
5.7 Recovery and Atomicity
5.8 Log based recovery
5.9 Locking mechanism
5.10 Deadlock
5.11 Twophase locking protocol
5.12 Isolation
5.13 Recovery System Failure classification
5.14 Recovery and atomicity
5.15 Log based recovery
5.16 Checkpoints
5.17 Buffer management
5.18 Introduction to Web databases
Download AI 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-4
Theory of computation
Microcontroller and embedded systems
Object oriented programming using java
Introduction to artificial intelligence
Mathematical foundations for artificial intelligence
Share
Link Copied
More than
1 Million
students use Goseeko! Join them to feel the power of smart learning.
Try For Free
Spot anything incorrect?
Contact us