GATE CS Mastery
My library

Formula SheetFDBGATE CS 2027

Databases Formula Sheet

Formulas • Symbols • Conditions • Traps • Recall

A4 rule and reference sheet for GATE CS Databases: ER to table mapping, counting super keys, relational algebra result sizes and division, tuple calculus, SQL evaluation order and NULL logic, attribute closure, candidate keys, minimal cover, normal forms, lossless and dependency-preserving decomposition, blocking factor, B and B+ tree order, index levels, conflict and view serializability, recoverability, two-phase locking, timestamp ordering and log-based recovery.

  • 9 A4 pagesone topic per page
  • PDF (A4)Version 1.0.1
  • Screen editionPhones, tablets, laptops
  • Print editionPrepared for A4 printing

₹19Regular price ₹29Launch price

Launch price: ₹19 instead of the regular ₹29.

Page 1 of 9

3 of 9 pages shown as images. The purchased PDF is sharper, searchable and has clickable bookmarks.

Page 1 of 9

What is inside

9 pages, one purpose each

  1. p. 1Cover, contents and how to useThe page map, a key to every box type, and the order to read on the last day.
  2. DB-F02ER Model, Keys, ConstraintsMapping to tables, super key counts, integrity rules
  3. DB-F03Relational Algebra, Tuple CalculusOperators, result sizes, division, equivalent forms
  4. DB-F04SQLEvaluation order, NULLs, joins, aggregates, subqueries
  5. DB-F05Functional Dependencies, Normal FormsClosure, keys, minimal cover, NF tests, decomposition
  6. DB-F06File Organisation and IndexingBlocking factor, index sizes, B and B+ tree order, levels
  7. DB-F07Transactions and SchedulesACID, schedule counts, serializability, recoverability
  8. DB-F08Concurrency Control and RecoveryLocking, timestamps, deadlock schemes, log recovery
  9. DB-F09Confused Pairs and RecallPairs that get swapped, rules to recall cold

How each page works

Built for fast revision

  • Formula cards with every symbol defined
  • Use when: the question type the card answers
  • Trap: the mistake examiners set up
  • Worked examples
  • Reference tables
  • A closing page of confused pairs and Last-Minute Recall

About this pack

Scope

A rule and reference sheet for the Databases part of the GATE CS 2027 syllabus, organised as topic mini-sheets: ER and relational model with keys and constraints; relational algebra and tuple calculus; SQL; functional dependencies and normal forms; file organisation and indexing; transactions and schedules; and concurrency control and recovery. Most of this subject is rules, tests and tables rather than formulas. Each card states the rule, the condition under which it holds, and the trap students fall into; the counting and sizing formulas (super keys, B+ tree order, index levels, schedule counts) define every symbol. Every SQL result count on the sheet was checked by running the query, and every worked number by a script. A final page collects the pairs students confuse and a Last-Minute Recall list. It is a revision aid for students who have already studied the topics; it does not replace a textbook or a course.

Is it right for you?

Who it is for, and how you get it

Who it is for

GATE CS 2027 candidates who have studied the subject and want fast, reliable revision: one page per sitting of about ten minutes, then the last-day sheet before the exam.

Screen edition

For phones, tablets and laptops. Clickable bookmarks jump between pages.

Print edition

The same pages prepared for A4 printing. Both editions are included.

Preparing more than one subject?Complete GATE CS Formula Sheet CollectionAll 12 packs including Databases Formula Sheet, for ₹149 (launch price).

Before you buy

Common questions

What exactly will I receive?

A 9-page A4 PDF in two editions: a screen edition for reading on a device and a print edition prepared for A4 printing. Nothing is shipped; it is a download.

Can I read it on my phone, and can I print it?

Yes. The PDF opens in any PDF reader on phones, tablets and computers, and the bookmarks jump between pages. You may print it for your own study.

Is it for GATE 2027?

Yes. The packs follow the official GATE CS 2027 syllabus, and each pack says what is in scope and what is covered in another pack. GATE CS Mastery is independent and not affiliated with IIT, IISc or the GATE organising committee.

How is this different from ordinary short notes?

Each page answers one question and uses labelled boxes: rules with their conditions, traps with the fix, comparison tables and small worked examples. Every pack ends with a traps sheet, a question-patterns sheet and a one-page last-day sheet.

What happens after I pay?

When Razorpay confirms the payment, download buttons appear straight away and a receipt is emailed to you. Later, My library sends a one-time link to your purchase email and shows fresh download links.

What if the payment succeeds but the download fails?

Do not pay again. Your purchase is recorded as soon as the payment is verified. Open My library, or write to support@gatecsmastery.com with your order ID or Razorpay payment ID. See the refund policy for when a refund applies.