Subject Details
Dept     : CSE
Sem      : 4
Regul    : 2023
Faculty : swathi G
phone  : NIL
E-mail  : swathi.g.cse@snsct.org
324
Page views
22
Files
0
Videos
0
R.Links

Icon
Lecture Notes

UNIT 1:
pdf
download    open file
Purpose of DBMS,View of data
pdf
download    open file
Components of DBMS
pdf
download    open file
Data Models
pdf
download    open file
pdf
download    open file
Entity Relational Model
pdf
download    open file
ER Diagram Notation
pdf
download    open file
Examples of ER Diagram
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
Table,forign keys
pdf
download    open file
SQL fundamentals - Introduction, data definition in SQL
pdf
download    open file
Intermediate SQL
pdf
download    open file
Embedded SQL
pdf
download    open file
Dynamic SQL
pdf
download    open file
CASE Studies- OracleDatabase Design and Querying Tools; SQL Variations and Extensions
pdf
download    open file
Advanced SQL features
UNIT 3:
DEPENDENCIES
Normalization - 1NF,2NF
Normalization - 3NF and Boyce Codd NF
4 NF AND 5 NF
CLOSURE OF A SET OF FD's , MINIMAL COVERS AND NON-LOSS DECOMPOSITION
Armstrong axioms