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 34
34 topics
01
Basic Database Concepts
02
Database Approach vs File Based System
03
Database Architecture
04
Three Level Schema Architecture
05
Data Independence
06
Relational Data Model
07
Attributes
08
Schemas
09
Tuples
10
Domains
11
Relation Instances
12
Keys of Relations
13
Integrity Constraints
14
Relational Algebra
15
Selection in Relational Algebra
16
Projection in Relational Algebra
17
Cartesian Product in Relational Algebra
18
Types of Joins
19
Normalization
20
Functional Dependencies
21
Normal Forms
22
Entity-Relationship Model
23
Entity Sets
24
Attributes in Entity-Relationship Model
25
Relationship in Entity-Relationship Model
26
Entity-Relationship Diagrams
27
Structured Query Language (SQL)
28
Joins in SQL
29
Sub-Queries in SQL
30
Grouping and Aggregation in SQL
31
Concurrency Control
32
Database Backup and Recovery
33
Indexes
34
NoSQL Systems
Past Papers
Open this section to load past papers
Click on Show Past Papers to see past papers.