Lecture Notes || SNS Courseware

Subject Details

Dept : AIML

Sem : 4

Regul : 2019

Faculty : Ms.A.Aruna

phone : NIL

E-mail : aruna.a.it@snsct.org

219

Page views

Files

Videos

R.Links

Lecture Notes

UNIT 1:

Purpose of Database System

Database Management system - Three-schema architecture of DBMS

Components of DBMS

Entity –Relationship Model

Entities, entity types, attributes

Relationships, relationship types

E/R diagram notations, Examples

Views of data – Data models

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

Intermediate SQL

Advanced SQL features

Oracle:Database Design and Querying Tools; SQL Variations and Extensions

UNIT 3:

Dependencies and Normal forms

Functional Dependencies

minimal covers-Non- loss decomposition

First,Second,Third Normal Forms

Dependency Preservation-Boyce/Codd Normal Form

Multivalued Dependencies and Fourth Normal Form

Join Dependencies and Fifth Normal Form

UNIT 4:

Transaction Concepts – ACID Properties

Schedules – Serializability

Concurrency Control – Need for Concurrency

Deadlock – Transaction Recovery

Isolation Levels

UNIT 5:

Data Storage and Indexes – RAID

File organization-Indexing and Hashing –Ordered Indices

MongoDB-Installing and Set up

Lecture Notes

Announcements

Recent Files

Copyright © SNS College Of Engineering 2014 Developed bySNSCE