BIT · Semester III
Database Management System syllabus
Official TU syllabus for Database Management System (BIT202): 10 units, 68 topics. Every unit links to its notes and solved questions.
1
Database Fundamentals and Architecture
8 Q- Database definition and characteristics
- Advantages of DBMS over file systems
- Three-schema architecture layers
- Logical and physical data independence
- Database users and roles
- Data models, schemas, and instances
2
Entity-Relationship Model
7 Q- ER diagram purpose and symbols
- Entities and attributes
- Attribute types and derived attributes
- Relationships and cardinality
- Weak entities and partial keys
- Generalization and specialization
- Extended ER model constraints
3
Relational Data Model
5 Q- Relational model definition
- Relations versus flat files
- Relation, instance, and schema
- Attributes and domains
- Primary keys and foreign keys
- Integrity constraints
- Referential integrity
4
ER to Relational Mapping
2 Q- Mapping entities to relations
- Mapping one-to-many relationships
- Mapping many-to-many relationships
- Mapping weak entities
- Mapping specialization and generalization
5
Normalization and Database Design
6 Q- Normalization purpose and need
- Functional dependencies
- First normal form
- Second normal form
- Third normal form
- Quality measures for relational schema design
6
SQL and Query Processing
9 Q- SQL data definition language
- SQL data manipulation language
- Create table statements
- Update and delete operations
- Cascade on delete
- Outer joins
- Group by and having clauses
- Views and view creation
- Relational algebra operations
7
Transaction Management
8 Q- Transaction definition
- ACID properties
- Transaction states and state diagram
- Serial and non-serial schedules
- Serializable schedules
- Conflict serializability testing
- Lost update problem
- Dirty read problem
- Incorrect summary problem
8
Concurrency Control
5 Q- Concurrent execution in multiuser systems
- Need for concurrency control
- Binary locks
- Shared and exclusive locks
- Two-phase locking protocol
- Deadlock definition and examples
- Starvation in DBMS
9
Database Recovery and Reliability
5 Q- Database recovery definition
- System log and log entries
- Types of failures
- Catastrophic failure
- Shadow paging technique
- Recovery using shadow paging
10
NoSQL and Unstructured Data
5 Q- Structured and unstructured data
- NoSQL definition and characteristics
- NoSQL types and models
- NoSQL advantages
- Data storage and retrieval in NoSQL
- NoSQL query languages
Study BIT202 the smart way
Solved questions, flashcards & practice