Subject Details
Dept     : CSE
Sem      : 4
Regul    : 2019
Faculty : Subhashree P
phone  : NIL
E-mail  : subashree.p.cse@snsct.org
306
Page views
42
Files
2
Videos
0
R.Links

Icon
Lecture Notes

UNIT 1:
word
download   open file
Purpose of DBMS,Views of Data
word
download   open file
Components of DBMS
word
download   open file
Data Models
word
download   open file
DBMS Three schema architecture
word
download   open file
Entity Relationship model
word
download   open file
ER Diagram notations
UNIT 2:
word
download   open file
Relational Data Model - keys, referential integrity and foreign keys
word
download   open file
Relational Algebra
word
download   open file
SQL fundamentals - Introduction, data definition in SQL
word
download   open file
Table, key and foreign key definitions, update behaviors
word
download   open file
Advanced SQL features
word
download   open file
Embedded SQL
word
download   open file
Intermediate SQL
word
download   open file
Dynamic SQL
word
download   open file
CASE Studies- OracleDatabase Design and Querying Tools; SQL Variations and Extensions
UNIT 3:
word
download   open file
Dependencies
word
download   open file
Normal Forms
word
download   open file
Functional Dependency
word
download   open file
Armstrong Axioms
word
download   open file
Minimal Cover
word
download   open file
2NF,3NF
word
download   open file
4NF and 5NF
word
download   open file
BCNF
word
download   open file
Join Dependency
UNIT 4:
word
download   open file
Transaction Concepts – ACID Properties
word
download   open file
SCHEDULE
word
download   open file
Serializability
word
download   open file
Concurrency Control – Need for Concurrency
word
download   open file
Locking Protocols
word
download   open file
Two Phase Locking
word
download   open file
Deadlock – Transaction Recovery
word
download   open file
Save Points – Isolation Levels
word
download   open file
SQL Facilities for Concurrency and Recovery
UNIT 5:
word
download   open file
Data Storage
word
download   open file
RAID
word
download   open file
File Organisation
word
download   open file
Indexes
word
download   open file
Hashing
word
download   open file
Ordered Indicies
word
download   open file
B-Tree Index file
word
download   open file
B+ Tree
word
download   open file
Query Processing Overview