Lecture Notes || SNS Courseware

Subject Details

Dept : CSE

Sem : 4

Regul : 2019

Faculty : Jacquelin Anushya

phone : NIL

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

594

Page views

49

Files

1

Videos

2

R.Links

Lecture Notes

UNIT 1:

Purpose of Database System -– Views of data

Data models, Database Management system -

Database Management system - Three-schema architecture of DBMS,

Components of DBMS

Entity –Relationship Model

E/R diagram notations,

E/R diagram notations, Examples

UNIT 2:

Relational Data Model - keys, referential integrity and foreign keys

Relational Algebra

SQL fundamentals

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,Third Normal Forms,

Fourth Normal Form,Fifth Normal Form

Boyce/Codd Normal Form

Join Dependency

minimal covers

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

Indexes

B+Tree

B -tree index file

File organisation

Hashing

Ordered indicies

Query processing overview

RAID

Lecture Notes

Announcements

Recent Files

Copyright © SNS College Of Engineering 2014 Developed bySNSCE