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.
Spot anything incorrect? Contact us