Database Systems
This subject walks you through the most important concepts step by step, starting from the foundations and moving towards practical exam-focused preparation. Use this page as your central place to revise topics, jump into notes, and quickly access practice material when you need it.
U1
General Topics
topic 1 to 22
22 topics
01
Basic Database Concepts
02
Entity Relationship Modelling
03
Relational Data Model and Algebra
04
Structured Query Language (SQL)
05
RDBMS
06
Database Design
07
Functional Dependencies
08
Normal Forms
09
Transaction Processing
10
Optimization Concepts
11
Concurrency Control
12
Recovery Techniques
13
Database Security and Authorization
14
Small Group Project Implementing a Database
15
Physical Database Design
16
Storage and File Structure
17
Indexed Files
18
B-Trees
19
Files with Dense Index
20
Files with Variable Length Records
21
Database Efficiency
22
Database Tuning
Past Papers
Open this section to load past papers
Click on Show Past Papers to see past papers.