Notes for Database Engineering - DE by 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

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

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

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

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

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

Evaluation of Relational Algebra Expressions Query 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