Connected successfully Lecture Notes || SNS Courseware
Subject Details
Dept     : CSE-IOT
Sem      : 5
Regul    : 2019
Faculty : Ms K Sangeetha
phone  : 8667402835
E-mail  : sangeetha.k.iot@snsce.ac.in
162
Page views
22
Files
2
Videos
3
R.Links

Icon
Lecture Notes

UNIT 1:
pdf
download    open file
Views of data–Data models
pdf
download    open file
Introduction to Database System
pdf
download    open file
Purpose of Data base System
pdf
download    open file
Components of DBMS
pdf
download    open file
Three-schema architecture of DBMS
pdf
download    open file
Database Management system
UNIT 2:
pdf
download    open file
Basics of SQL,DDL,DML,DCL
pdf
download    open file
structure–creation,alteration,definingconstraints–Primarykey, foreign key, unique, not null,
pdf
download    open file
structure–creation,alteration,definingconstraints–Primarykey, foreign key, unique, not null,
pdf
download    open file
Basics of SQL,DDL,DML,DCL
pdf
download    open file
Cursors
pdf
download    open file
structure–creation,alteration,definingconstraints–Primarykey, foreign key, unique, not null,
pdf
download    open file
Built-in functions – numeric, date, string functions,
UNIT 3:
pdf
download    open file
E-R Issues- weak entity set, code rules
pdf
download    open file
Dependencies and Normal forms-Functional Dependencies
pdf
download    open file
ER Diagrams -Entities, Attributes, Relationships
pdf
download    open file
DATABASE DESIGN: Database Design Process
pdf
download    open file
Constraints, keys, extended ER features
pdf
download    open file
Normalizations:1NF,2NF,3NF,BCNF,4NF,5NF