Syllabus (DBMS)

  2BCA Notes All previous year paper

Database Management

Database Management

Introduction To Database System : Data - Database Applications -Advantages - Evolution of DB & DBMS- Need for data management, Introduction and applications of DBMS, File systems vS Database systems, Data Models, DBMS Architecture, Data Independence, Data Modeling using Entity-Relationship Model, Enhanced ER Modeling( English).data dictionary

UNIT - II

Relational Database Concept and Design: Introduction to relational database, Structure of Relational Database, Relational model terminology(English) domains, Attributes, Tuples, Relations  , relational DB schema. Relational algebra:  Set Theoretic projection, Select ion, operations Union, Intersection, set difference and division, Join operations: Inner,Outer, Left outer, Right outer and full outer join. Relational Database design, Functional Dependency, definition, trivial ki 7 and nontrivial FD, Normalization 1Nf, 2NF, 3NF,Decomposition using FD dependency preservation, BCNF, Multi valued dependency, 4NF,Join dependency and 5NF.

UNIT - III

Database storage and querying (English)-Basic Concepts of Indexing and Hashing Query Processing,Measures Of Query Cost, Query Processing for Select, Sort ,Join Operations, Basics of Query Optimization(English ), Transformation of Relational Expression( English) Estimating Statistics of Expression( English), Choice of Evaluation Plan link.

UNIT - IV

Concurrency, Recovery and Security -Concurrency Control: Definition of concurrency, lost update, dirty read and incorrect summary problems due to concurrency. (English)Concurrency Control Techniques: Overview of Locking, 2PL, Timestamp ordering, multi-versioning (English), validation Recovery concepts, Shadow paging, Log Based Recovery, Elementary concepts of Database security: system failure, Backup and Recovery Techniques, authorization and authentication.

UNIT - V

Introduction to Current Trends (English)– Centralized and Client Server Architectures, Distributed Databases(Fragment), Object Oriented Database(English), Spatial & Temporal Databases(English), Data Mining & Warehousing, Data Visualization, Mobile Databases( English), OODB & XML Databases, Multimedia & Web Databases.