Lecture Notes || SNS Courseware

Subject Details

Dept : CSD

Sem : 3

Regul : 2019

Faculty : Parvathi

phone : xxxxxxxx

E-mail : parvathi.r.csd@snsce.ac.in

150

Page views

Files

Videos

R.Links

Lecture Notes

UNIT 1:

Purpose of Database System

Views of data

Data Models

Database System Architecture

Introduction to relational databases

Relational Model â€“ Keys

Relational Algebra

SQL fundamentals

Advanced SQL features

Embedded SQLâ€“ Dynamic SQL

UNIT 2:

Entity-Relationship model

E-R Diagrams

Enhanced-ER Model

ER-to-Relational Mapping

Functional Dependencies

Non-loss Decomposition

Boyce/Codd Normal Form

Multivalued Dependencies and Fourth Normal Form

Join Dependencies and Fifth Normal Form

UNIT 3:

Transaction Concepts

ACID Propertie

Transaction support in SQL

chedules â€“ Serializability

Transaction support in SQL

Need for Concurrency â€“ Concurrency control

UNIT 4:

full notes of unit4

UNIT 5:

full notes of unit 5

Lecture Notes

Announcements

Recent Files

Copyright © SNS College Of Engineering 2014 Developed by SNSCE