PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2023 paper

Unit 2: Relational Query Languages

20237m

A 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) BCNF
Search GoogleAsk AI
Worked SolutionAI Assisted

Answer: (ii) 2 NF

Explanation: 1NF - atomic values, no repeating groups.
2NF - is in 1NF and every non-prime attribute is fully functionally dependent on the primary key (no partial dependency where non-prime depends on part of composite key).
3NF eliminates transitive dependency (non-prime depends on another non-prime).
BCNF is stronger 3NF where every determinant is a superkey.

The description "every non-prime attribute is fully dependent on prime attribute" actually describes 2NF partial dependency removal (taught as 2NF definition). Hence answer is 2NF. Note: strict formal definition: In 2NF, no non-prime attribute is partially dependent on any candidate key.

Similar questions

Database Management SystemWhich normal form is considered adequate for normal relational database design? (i) 2 NF (ii) 5 NF (iii) 4 NF (iv) 3 NF20222mDatabase 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 SYSTEMBCNF stands for - (i) Boyle Cold Normalization Form - (ii) Boyce Cold Normal Form - (iii) Boyce Codd Normal Form - (iv) None of these20232mDatabase Management SystemExplain different normal forms up to BCNF with examples.20257m
PreviousA row from a table is selected by - (i) selection operator - (ii) projection operator - (iii) union operator - (iv) none of theseNextSerializability of concurrent transaction is ensured by - (i) locking - (ii) time stamping - (iii) both (a) and (b) - (iv) none of these
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