Name: Notes for Database Systems - DS by BIJAYA PANDA
Rating: 4.3 (71 reviews)
Author: BIJAYA KUMAR PANDA

Introduction to database Systems, advantages of database system over traditional file
system, Basic concepts & Definitions, Database users, Database Language, Database System
Architecture, Schemas, Sub Schemas, & Instances, database constraints, 3-level database
architecture, Data Abstraction, Data Independence, Mappings, Structure, Components &
functions of DBMS, Data models

Database Systems

Entity relationship model, Components of ER model, Mapping E-R model to Relational
schema, Network and Object Oriented Data models, Storage Strategies: Detailed Storage
Architecture, Storing Data, Magnetic Disk, RAID, Other Disks, Magnetic Tape, Storage
Access, File & Record Organization, File Organizations & Indexes, Order Indices, B+ Tree
Index Files, Hashing Data Dictionary

Entity Relationship Model

Relational Algebra, Tuple & Domain Relational Calculus, Relational Query Languages: SQL
and QBE. Database Design :-Database development life cycle (DDLC), Automated design
tools, Functional dependency and Decomposition, Join strategies, Dependency Preservation
& lossless Design, Normalization

Relational Algebra

SQL Schema Definition, Basic Constraints and Queries

Sql Schema Definition Basic Constraints And Queries

Query processing and optimization: Evaluation of Relational
Algebra Expressions, Query optimization, Query cost estimation.

Query Processing And Optimization

Normalization, Normal forms:1NF, 2NF,3NF, and BCNF, Multi-valued
Dependencies, 4NF & 5NF.

Normalization

Transaction concepts, properties of
transaction, concurrency control, locking and Timestamp methods for concurrency control
schemes

Transaction Processing

Database Recovery System, Types of Data Base failure & Types of Database
Recovery, Recovery techniques.

Database Recovery System

Types Of Failure

fundamental concepts on Object-Oriented Database, Object
relational database, distributed database, Parallel Database, Data warehousing & Data
Mining and Big data and NoSQL.

Object Oriented Database

 Professor, GITA, Bhubaneswar

BIJAYA KUMAR PANDA

Notes for Database Systems - DS by BIJAYA PANDA