Subject Details
Dept     : CSE
Sem      : 4
Regul    : 2023
Faculty : Jacquelin Anushya
phone  : NIL
E-mail  : janushya.p.cse@snsct.org
221
Page views
30
Files
1
Videos
2
R.Links

Icon
Lecture Notes

UNIT 1:
pdf
download    open file
Purpose of Database System, Views of data
pdf
download    open file
Data Models
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, relationships
pdf
download    open file
Relationship types
pdf
download    open file
E/R diagram notations, Examples
pdf
download    open file
E/R diagram notations, Examples
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, data definition in SQL
pdf
download    open file
Table, key and foreign key definitions, update behaviors
pdf
download    open file
Intermediate SQL
pdf
download    open file
Advanced SQL features
pdf
download    open file
Embedded SQL
pdf
download    open file
Dynamic SQL
pdf
download    open file
CASE Studies- Oracle:Database Design and Querying Tools; SQL Variations and Extensions
UNIT 3:
pdf
download    open file
First, Second Normal Forms
pdf
download    open file
Third Normal Forms
pdf
download    open file
Join Dependencies and Fifth Normal Form
pdf
download    open file
Dependency Preservation –Boyce/Codd Normal Form
pdf
download    open file
Multi-valued Dependencies and Fourth Normal Form
pdf
download    open file
Dependencies and Normal forms - Functional Dependencies
pdf
download    open file
Armstrong's axioms for FD's
pdf
download    open file
Closure of a set of FD's, minimal covers
pdf
download    open file
Non- loss decomposition
pdf
download    open file
Closure of a set of FD's, minimal covers