Connect with fellow learners in the PlacePrep Discord communityㆍ Join now →

R's PlacePrep

Popular drives

TCSNQT (National Qualifier Test)InfosysIRT (InfyTQ Recruitment Test)AccentureCognitive & Technical Assessment

Also hiring

WiproNLTH (National Level Talent Hunt)CognizantGenC Assessment CapgeminiGame-Based Assessment

Browse all 14 companies TCS NQT 2026

Real placement papers from the drives you are actually sitting for

14 companies · 48 papersStart practising

Select your branch

Computer Science & EngineeringBEU previous year papers and solutions Mechanical EngineeringBEU previous year papers and solutions Electrical & Electronics EngineeringBEU previous year papers and solutions

More branches

Civil EngineeringBEU previous year papers and solutions Aeronautical EngineeringBEU previous year papers and solutions

All branches Computer Science

Previous year questions

University papers, sorted by subject and year with worked solutions

BEU Solved PapersOpen the archive

Core CS

Data Structures & AlgorithmsComplexity analysis up to graphs and DP.Operating SystemsProcesses, scheduling, memory and concurrency.Database Management SystemsRelational modelling, transactions and indexing.Computer NetworksFrom wires and radio waves up to the web.

Learn & scale

AI Inference EngineeringQuantization, batching and KV caching in production.System DesignScalable systems from first principles.Context EngineeringDesigning the context that LLMs actually reason over.Docker & KubernetesContainers and orchestration, explained.

All 15 courses Authors

Structured courses that start at zero and end somewhere useful

15 courses · free foreverBrowse courses

Companies PYQ Learn

Database Management Systems

Foundations of DBMS6

Relational Model, Algebra & Calculus6

Integrity Constraints & Normal Forms6

A complete tour of integrity constraints
Functional dependencies and Armstrong's axioms
First, Second, and Third Normal Form
Boyce-Codd Normal Form (BCNF)
Multivalued dependencies, 4NF, and 5NF
Decomposition properties — lossless join and dependency preservation

File Organization & Indexing7

Transactions & Concurrency Control9

Query Processing, Optimization & Distributed DBs5

Lessons

Contribute, invite only

Database Management Systems

Foundations of DBMS6

Relational Model, Algebra & Calculus6

Integrity Constraints & Normal Forms6

A complete tour of integrity constraints
Functional dependencies and Armstrong's axioms
First, Second, and Third Normal Form
Boyce-Codd Normal Form (BCNF)
Multivalued dependencies, 4NF, and 5NF
Decomposition properties — lossless join and dependency preservation

File Organization & Indexing7

Transactions & Concurrency Control9

Query Processing, Optimization & Distributed DBs5

Learn Database Management Systems Integrity Constraints & Normal Forms

Contribute, invite only

Boyce-Codd Normal Form (BCNF)

The subtle gap 3NF leaves open with overlapping candidate keys, the stricter BCNF definition that closes it, and why BCNF sometimes trades away dependency preservation.

9 min readUpdated 2026-09-04dbmsnormalizationbcnf