Lecture Notes || SNS Courseware

Subject Details

Dept : MCA

Sem : 2

Regul : 2019

Faculty : Yuvarani E

phone : NIL

E-mail : learnlearnn@gmail.com

697

Page views

Files

Videos

R.Links

Lecture Notes

UNIT 1:

Introduction

Historical perspective

Files versus database systems

Architecture

E-R model

Security and Integrity

Data models Physical, Logical Model

Data model View model

UNIT 2:

The relation

Keys

Constraints

Relational algebra and Calculus

Relation calculus queries

Programming and triggers

Queries - Join Types and Queries

UNIT 3:

Disks and Files

RAID Levels

File organizations

Indexing

Primary Indexing

Tree structured indexing

Hash Based indexing

UNIT 4:

External sorting

Concurrency control

Query evaluation

Schema refinement and normalization

Query optimization

Schema refinement and normalization

Physical database design and tuning

Concurrency control

UNIT 5:

Introduction

CRUD operations with MongoDB

Indexing and ordering datasets

NOSQL Storage Architecture

Lecture Notes

Announcements

Recent Files

Copyright © SNS College Of Engineering 2014 Developed bySNSCE