Lecture Notes || SNS Courseware

Subject Details

Dept : AIDS

Sem : 3

Regul : 2022

Faculty : Revathi

phone : NIL

E-mail : revathi.k.it@snsce.ac.in

145

Page views

Files

Videos

R.Links

Lecture Notes

UNIT 1:

Three- schema architecture of DBMS,

Components of DBMS. Entity –Relationship Model

Views of data – Data models, Database Management system

Conceptual data modeling - motivation, entities, entity types, attributes, relationships, relationship types, E/R diagram notations, Examples

Purpose of Database System

UNIT 2:

Relational Data Model

Relational Algebra

Intermediate SQL-Advanced SQL features

UNIT 3:

First,Second,Third Normal Forms

Boyce/Codd Normal Form-Multivalued

Join Dependencies and Fifth Normal Form

UNIT 4:

Transaction Concepts

Schedules

ACID Properties

Transaction Concepts

Serializability

Announcements

Recent Files

Sep