PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2023 paper

Unit 2: Relational Query Languages

20232m

BCNF stands for

  • (i) Boyle Cold Normalization Form
  • (ii) Boyce Cold Normal Form
  • (iii) Boyce Codd Normal Form
  • (iv) None of these
Search GoogleAsk AI
Worked SolutionAI Assisted

Answer: (iii) Boyce Codd Normal Form

Explanation: BCNF = Boyce-Codd Normal Form (stronger than 3NF). Developed by Raymond Boyce and Edgar Codd. Condition: For every functional dependency X -> Y, X is a superkey. Options (i) and (ii) are distractors with misspelling.

Similar questions

DATABASE MANAGEMENT SYSTEMA normal form in which every non-prime attribute is fully dependent on prime attribute is - (i) 1 NF - (ii) 2 NF - (iii) 3 NF - (iv) BCNF20237mDatabase Management SystemExplain different normal forms up to BCNF with examples.20257mDatabase Management SystemA relation is in BCNF if: (i) Every non-prime attribute depends on key (ii) Every FD is trivial (iii) Every determinant is a superkey (iv) Every attribute is atomic20252mDatabase Management SystemWhich normal form is considered adequate for normal relational database design? (i) 2 NF (ii) 5 NF (iii) 4 NF (iv) 3 NF20222m
PreviousWhich key cannot be null - (i) Unique key - (ii) Primary key - (iii) Super key - (iv) Foreign key
Official AppAndroid App

PYQDeck for Android

Solve BEU previous-year exam papers anywhere, anytime. Fast search, offline paper viewing, and step-by-step solutions designed specifically for your phone.

Get on Google Play