IEMCET computing preparation: Relational keys — error clinic and diagnostic check

The error pattern

Treating every identifier-looking column as a guaranteed key ignores declared constraints and actual semantics.

An error clinic starts with the reason an approach fails, rather than memorising an exception in isolation. State the hidden assumption or changed definition that makes the mistaken approach tempting.

Rebuild the correct model

A candidate key minimally identifies a row. A primary key is a selected candidate key; foreign keys relate tables under constraints.

Uniqueness and minimality both matter for a candidate key.

State the representation and computational model: indexing convention, bit width, data-structure operations, graph assumptions, language rules or protocol service. Follow the operation sequence explicitly. A result under one model is not automatically valid under a different representation.

Diagnostic question

Does a foreign-key column have to be unique in the referencing table?

Before solving, write one sentence explaining how the error pattern above could affect this question. Then choose a method that keeps the correct definition, convention or model visible.

Diagnostic answer

Not generally; many rows can reference the same parent row.

Compare the actual reasoning steps, not only the final value or chosen word. A correct final result obtained from inconsistent assumptions is not a dependable method for a different problem.

Verification checklist

Trace a small example and a boundary case. Distinguish correctness from complexity, a necessary condition from a sufficient one, and declared constraints from coincidences in sample data. Check whether the question asks for an exact count, a bound or a qualitative property.

Keep an error-log entry with the topic, the failed step, the corrected principle and a later reattempt. Track whether the same failure recurs. The purpose is to improve reasoning on this topic; the log is not a certificate of examination performance.

Official sources and verification

Sources checked on 26 October 2026. A source’s date, programme and campus limit which claims it supports. Official pages may change after review.

1. UEM Kolkata — IEMCET 2026 syllabus and instructions

   Historical course-specific preparation guidance. Some introductory route text conflicts with the central portal.

2. WBJEEB — JECA 2026 information bulletin

   2026 MCA syllabus and institution modules; Appendix 10 includes IEM Salt Lake. Historical, not a 2027 seat guarantee.

3. IIT Madras — GATE 2027 Computer Science syllabus

   Current GATE CS topic reference; IEMCET adoption of every 2027 revision is not asserted. MCA eligibility and programme paper instructions remain separate.

Found a discrepancy? Send the page and the official notice for correction.