Official Bihar Engineering University examination question papers, marks distribution, and questions transcript. Available exam sessions: 2025, 2022, 2020, 2019, 2017.
Open BEU Connect Android app to solve any numerical or derive formulas step by step.
No paper transcript available.
Official BEU curriculum units & topics for this examination subject.
Unit 1.0: Database system architecture
Data Abstraction • Data Independence • Data Definition Language (DDL) • Data Manipulation Language (DML) • Data models: Entity-relationship model • Network model • Relational and object oriented data models • Integrity constraints • Data manipulation operations
Unit 2.0: Relational query languages
Relational algebra • Tuple and domain relational calculus • SQL3 • DDL and DML constructs • Open source and Commercial DBMS - MYSQL • ORACLE • DB2 • SQL server • Relational database design: Domain and data dependency • Armstrong's axioms • Normal forms • Dependency preservation • Lossless design • Query processing and optimization: Evaluation of relational algebra expressions • Query equivalence • Join strategies • Query optimization algorithms
Unit 3.0: Storage strategies
Indices • B-trees • Hashing
Unit 4.0: Transaction processing
Concurrency control • ACID property • Serializability of scheduling • Locking and timestamp based schedulers • Multi-version and optimistic Concurrency Control schemes • Database recovery
Unit 5.0: Database Security
Authentication • Authorization and access control • DAC, MAC and RBAC models • Intrusion detection • SQL injection