Lecture Notes || SNS Courseware

Subject Details

Dept : CSE

Sem : 4

Regul : 2023

Faculty : Jacquelin Anushya

phone : NIL

E-mail : janushya.p.cse@snsct.org

481

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

Conceptual data modeling - motivation

Entities, entity types, attributes, relationships

Relationship types

E/R diagram notations, Examples

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:

First, Second Normal Forms

Third Normal Forms

Join Dependencies and Fifth Normal Form

Dependency Preservation –Boyce/Codd Normal Form

Multi-valued Dependencies and Fourth Normal Form

Dependencies and Normal forms - Functional Dependencies

Armstrong's axioms for FD's

Closure of a set of FD's, minimal covers

Non- loss decomposition

Closure of a set of FD's, minimal covers

UNIT 4:

Concurrency Control - Need for Concurrency

Transaction Concepts - ACID Properties

Deadlock - Transaction Recovery

Locking Protocols

Save Points -Isolation Levels

Schedules

Serializability

SQL Facilities for Concurrency and Recovery.

Two Phase Locking

UNIT 5:

B+ tree

B tree Index Files

Data Storage

File organization

Hashing

Ordered Indices

Indexes

Query Processing Overview

RAID

Lecture Notes

Announcements

Recent Files

Copyright © SNS College Of Engineering 2014 Developed by SNSCE