Lecture Notes || SNS Courseware

Subject Details

Dept : MCA

Sem : 1

Regul : 2013

Faculty : Yuvarani E

phone : NIL

E-mail : learnlearnn@gmail.com

488

Page views

Files

Videos

R.Links

Lecture Notes

UNIT 1:

Data Independence

DBMS Architecture

Data Models

File systems versus Database systems

Revision

Relationship Model

Data Modeling using Entity

Introduction

Revision

UNIT 2:

Relational Algebra - Tuple and Domain Relational Calculus

Relational Algebra

Relational Model Concepts

SQL Basic Queries

Complex SQL Queries

Views

Constraints

Revision

Relational Model Concepts

UNIT 3:

Dependencies

Non-loss Decomposition

First, Second, Third Normal Forms

Revision

Dependency Preservation

UNIT 4:

Triggers

Schema Modification More Complex SQL Retrieval Queries

Schema Change Statements in SQL

Specifying Constraints as Assertions and Actions as Triggers

Views

Views (Virtual Tables) in SQL

UNIT 5:

Definition of NOSQL

NOSQL Storage Architecture

NOSQL Data stores

Indexing and ordering datasets

Modifying and Managing NOSQL Data stores

CRUD operations with MongoDB

Lecture Notes

Announcements

Recent Files

Copyright © SNS College Of Engineering 2014 Developed by SNSCE