Name: Notes for Database Engineering - DE by Animesh Swain
Rating: 4.4 (8 reviews)
Author: Animesh Swain

Introduction to database Systems Basic concepts Definitions Data Dictionary DBA File- oriented system vs Database System Database Language r nDatabase System Architecture-Schemas Sub Schemas Instances 3-level database architecture Data Abstraction Data Independence Mappings Structure Components r nfunctions of DBMS 

Introduction To Database Systems

Data models Mapping E-R model to Relational Network and Object r nOriented Data models types of Database systems r nStorage 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 Models E R Model

Relational Algebra Tuple Domain Relational Calculus Relational Query Languages SQL r nand QBE 

Relational Algebra

Database Design -Database development life cycle DDLC Automated design tools Functional dependency and Decomposition Dependency Preservation lossless Design Normalization Normal forms 1NF 2NF 3NF and BCNF Multi-valued Dependencies 4NF r n5NF 

Database Design

Transaction processing and concurrency control Transaction concepts concurrency control locking and Timestamp methods for concurrency control 

Transaction Processing And Concurrency Control

Database Recovery System Types of Data Base failure Types of Database Recovery Recovery techniques

Database Recovery System

Evaluation of Relational Algebra Expressions Query optimization 

Query Processing And Optimization

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

Notes for Database Engineering - DE by Animesh Swain

BPUT ·

DE