Subject Details
Dept     : CST
Sem      : 4
Regul    : 2023
Faculty : Ms.Nandhini D
phone  : 8248927488
E-mail  : nandhini.d.cst@snsce.ac.in
76
Page views
18
Files
2
Videos
3
R.Links

Icon
Syllabus

UNIT
1
INTRODUCTION

Purpose of Database System,Views of data,Data models, Database Management system,Three-schema architecture of DBMS, Components of DBMS. Entity,Relationship Model ,Conceptual data modeling,motivation, entities, entity types, attributes, relationships, relationship types, E/R diagram notations, Examples

UNIT
2
RELATIONAL MODEL

Relational Data Model -,keys, referential integrity and foreign keys, Relational Algebra ,SQL fundamentals,Introduction, data definition in SQL, table, key and foreign key definitions, update behaviors,Intermediate SQL,Advanced SQL features ,Embedded SQL,Dynamic SQL, CASE Studies,Oracle:Database Design and Querying Tools; SQL Variations and Extensions

UNIT
3
c

c

UNIT
4
v

v

UNIT
5
c

v

Reference Book:

v

Text Book:

v