Lecture Notes || SNS Courseware

Subject Details

Dept : CSE

Sem : 4

Regul : 2019

Faculty : vasuki S

phone : NIL

E-mail : vasuki.s.cse@snsct.org

688

Page views

Files

Videos

R.Links

Lecture Notes

UNIT 1:

Purpose of Database System, Views of data

Data Models

Database Management system - Three-schema architecture of DBMS

Components of DBMS

Entity-Relationship Model

Entities, entity types, attributes, relationships

E/R diagram notations, Examples

Relationship types

UNIT 2:

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:

Dependencies and Normal forms - Functional Dependencies

First, Second Normal Forms

Join Dependencies and Fifth Normal Form

Multi-valued Dependencies and Fourth Normal Form

Dependency Preservation –Boyce/Codd Normal Form

Third Normal Forms

First, Second Normal Forms

UNIT 4:

Transaction Concepts – ACID Properties

Schedules

Serializability

Concurrency Control – Need for Concurrency

Locking Protocols

Two Phase Locking

Deadlock – Transaction Recovery

Save Points – Isolation Levels

SQL Facilities for Concurrency and Recovery

UNIT 5:

Data Storage and Indexes

RAID- File organization

Indexing and Hashing

Ordered Indices

B+ Tree Index Files & B Tree Index Files

Static Hashing – Dynamic Hashing

Query Processing Overview

CASE Studies- Oracle,DB2: Storage and Indexing

MongoDB, Database creation and manipulation, Indexing and ordering

Lecture Notes

Announcements

Recent Files

Copyright © SNS College Of Engineering 2014 Developed bySNSCE