Databases GATE CS Syllabus : ER‐model. Relational model: relational algebra, tuple calculus, SQL. Integrity constraints, normal forms. File organization, indexing (e.g., B and B+ trees). Transactions and concurrency control.
Database Management and Warehousing GATE DA Syllabus : ER-model, relational model: relational algebra, tuple calculus, SQL, integrity constraints, normal form, file organization, indexing, data types, data transformation such as normalization, discretization, sampling, compression; data warehouse modelling: schema for multidimensional data models, concept hierarchies, measures: categorization and computations.
DBMS video Lectures and GATE CS & DA Previous Year Questions(PYQ) video Solutions and PDF notes by Monalisa Pradhan
Chapter 1 : Intro to DBMS & ER Model Lectures and GATE CS & DA PYQ
Reference Book
DATABASE SYSTEM CONCEPTS SIXTH EDITION Abraham Silberschatz ,Henry F. Korth , S. Sudarshan