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

Icon
Lecture Notes

UNIT 1:
word
download   open file
Purpose of Data,View of Data
word
download   open file
Component od DBMS
word
download   open file
Data Model
word
download   open file
DBMS,Three Schema Architecture
word
download   open file
Entity Relational Model
word
download   open file
ER Notation
word
download   open file
Examples of ER Diagram
UNIT 2:
word
download   open file
Table, key and foreign key definitions, update behaviors
word
download   open file
SQL fundamentals - Introduction, data definition in SQL
word
download   open file
Relational Data Model - keys, referential integrity and foreign keys
word
download   open file
Relational Algebra
word
download   open file
Intermediate SQL
word
download   open file
Embedded SQL
word
download   open file
Dynamic SQL
word
download   open file
CASE Studies- OracleDatabase Design and Querying Tools; SQL Variations and Extensions
word
download   open file
Advanced SQL features
UNIT 3:
word
download   open file
Dependencies
word
download   open file
Functional Dependency
word
download   open file
Join Dependency
word
download   open file
Minimal Cover
word
download   open file
Normal Forms
word
download   open file
BCNF
word
download   open file
Armstrong Axioms
word
download   open file
4NF and 5NF