Lecture Notes || SNS Courseware

Subject Details

Dept : IT

Sem : 4

Regul : 2019

Faculty : Ms.A.Aruna

phone : NIL

E-mail : aruna.a.it@snsct.org

939

Page views

Files

Videos

R.Links

Lecture Notes

Text book:

Database System Concepts

UNIT 1:

Purpose of Database system

Data models, Database Management system

Threeschema architecture of DBMS

Components of DBMS

Conceptual data modeling

E/R diagram notations, Examples

motivation, entities, entity types, attributes, relationships, relationship types

UNIT 2:

Relational Data Model - keys, referential integrity and foreign keys

SQL fundamentals- Introduction

Relational Algebra

Intermediate SQL

Advanced SQL features

Oracle:Database Design and Querying Tools; SQL Variations and Extensions

UNIT 3:

Dependencies and Normal forms

Functional Dependencies

Armstrong axioms for FD

closure of a set of FD

minimal covers-Non- loss decomposition

First,Second,Third Normal Forms

UNIT 4:

Transaction Concepts – ACID Properties

Schedules – Serializability

Lecture Notes