Puzzles || SNS Courseware

Subject Details

Dept : CSE

Sem : 4

Regul : R-2017

Faculty : Mr. Karthikeyan. K

phone : NIL

E-mail : sns.cse.karthik@gmail.com

1.668K

Page views

Files

Videos

R.Links

Puzzles

UNIT 1:

introduction to Database System

Views of data

Relational Model – Keys – Relational Algebra

Views of data and model

Database System Architecture

Introduction to relational databases

SQL fundamentals

Advanced SQL features

Embedded SQL– Dynamic SQL

UNIT 2:

Enhanced-ER Model and ER-to-Relational Mapping

Entity-Relationship model -E-R Diagrams

Functional Dependencies

First, Second Third Normal Forms,

Join Dependencies and Fifth Normal Form

UNIT 3:

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 4:

RAID – File Organization

File Organization – Organization of Records in Files

Indexing and Hashing –Ordered

Query optimization using Heuristics and Cost Estimation

Query Processing Overview

Static Hashing – Dynamic Hashing

Indices – B+ tree Index Files –B tree Index Files

UNIT 5:

Distributed Databases: Architecture

Data Storage, Transaction Processing

Object-based Databases: Object Database Concepts

Object-Relational features, ODMG Object Model

XML Databases: XML Hierarchical Model

XML Databases: XML Hierarchical Model - XQuery – Information

Retrieval: IR Concepts

Retrieval: IR Models -Queries in IR systems

Puzzles

Announcements

Recent Files

Copyright © SNS College Of Engineering 2014 Developed bySNSCE