Subject Details
Dept     : AIML
Sem      : 4
Regul    : 2023
Faculty : Ms.A.Aruna
phone  : NIL
E-mail  : aruna.a.it@snsct.org
427
Page views
45
Files
4
Videos
1
R.Links

Icon
Lecture Notes

UNIT 1:
pdf
download    open file
Views of data , Data models
pdf
download    open file
Purpose of Database System
pdf
download    open file
Database Management system , Three schema architecture of DBMS
pdf
download    open file
Database Management system , Three schema architecture of DBMS
pdf
download    open file
Components of DBMS
pdf
download    open file
Entity Relationship Model
pdf
download    open file
Conceptual data modeling - motivation
pdf
download    open file
Entities, entity types, attributes
pdf
download    open file
Entities, entity types, attributes
pdf
download    open file
Relationships, relationship types
UNIT 2:
pdf
download    open file
Relational Data Model , keys, referential integrity and foreign keys
pdf
download    open file
Relational Algebra
pdf
download    open file
SQL fundamentals , Introduction
pdf
download    open file
data definition in SQL, table, key and foreign key definitions, update behaviors
pdf
download    open file
Views, Tiggers, Joins, Constraints, Stored Procedure
pdf
download    open file
Intermediate SQL
pdf
download    open file
Advanced SQL features
pdf
download    open file
Embedded SQL,Dynamic SQL
UNIT 3:
pdf
download    open file
Dependencies and Normal forms
pdf
download    open file
Functional Dependencies
pdf
download    open file
Armstrong's axioms for FD's
pdf
download    open file
closure of a set of FD's
pdf
download    open file
minimal covers,Nonloss decomposition
UNIT 4:
pdf
download    open file
Transaction Concepts – ACID Properties
pdf
download    open file
Transaction Concepts – ACID Properties
pdf
download    open file
Schedules – Serializability
pdf
download    open file
Schedules – Serializability
pdf
download    open file
Concurrency Control – Need for Concurrency
pdf
download    open file
Locking Protocols
pdf
download    open file
Two Phase Locking
pdf
download    open file
Deadlock – Transaction Recovery
pdf
download    open file
Isolation Levels
UNIT 5:
pdf
download    open file
Data Storage and Indexes – RAID
pdf
download    open file
Data Storage and Indexes – RAID
pdf
download    open file
File organization-Indexing and Hashing –Ordered Indices
pdf
download    open file
B+ tree Index Files
pdf
download    open file
B tree Index Files
pdf
download    open file
Static Hashing – Dynamic Hashing
pdf
download    open file
Query Processing Overview
pdf
download    open file
Algorithm for sorting basics of MongoDB
pdf
download    open file
Procedural Language
pdf
download    open file
Algorithm for selection basics of MongoDB