Lecture Notes || SNS Courseware

Subject Details

Dept : CSE

Sem : 4

Regul : 2023

Faculty : vasuki S

phone : NIL

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

437

Page views

Files

Videos

R.Links

Lecture Notes

UNIT 1:

Relationship types

ER diagram notations, Examples

Entities, entity types, attributes, relationships

Conceptual data modeling - motivation

Entity-Relationship Model

Components of DBMS

Database Management system - Three-schema architecture of DBMS

Data Models

Purpose of Database System, Views of data

UNIT 2:

Table, key and foreign key definitions, update behaviors

SQL fundamentals - Introduction, data definition in SQL

Relational Algebra

Relational Data Model - keys, referential integrity and foreign keys

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

Armstrong's axioms for FD's

Closure of a set of FD's, minimal covers

First, Second Normal Forms

Third Normal Forms

Dependency Preservation –Boyce/Codd Normal Form

Multi-valued Dependencies and Fourth Normal Form

Join Dependencies and Fifth Normal Form

Non- loss decomposition

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 and optimization

Database creation and manipulation, Indexing and ordering

CASE Studies- Oracle,DB2: Storage and Indexing

MongoDB-Installing and Setup

Lecture Notes

Announcements

Recent Files

Copyright © SNS College Of Engineering 2014 Developed by SNSCE