Skip to content
GATEiit

GATE DA Database Management and Warehousing syllabus

Relational databases, SQL, normalization, data preparation and data warehouse modelling.

About Database Management and Warehousing in GATE DA

The GATE DA 2027 syllabus lists 7 topics under Database Management and Warehousing.

It is one of the 7 subjects that together carry 85 of the 100 marks (Data Science & AI subjects). General Aptitude adds 15 marks and is common to every paper. The exam has 65 questions (MCQ, MSQ and NAT) in 3 hours.

See the full GATE DA syllabus for every subject and the marks distribution.

Same material in another paper

Database Management and Warehousing topics

  • ER model
  • Relational model: relational algebra, tuple calculus and SQL
  • Integrity constraints and normal forms
  • File organization and indexing
  • Data types; data transformation: normalization, discretization, sampling and compression
  • Data warehouse modelling: schemas for multidimensional data models
  • Concept hierarchies; measures: categorization and computations

Database Management and Warehousing PYQs & weightage

Soon

GATE DA previous year questions (PYQs) on Database Management and Warehousing, with answers, solutions and topic-wise weightage, will appear here as they are published.