arrow
arrow
arrow
Given a relation scheme R (x, y, z, w) with functional dependencies set F = {x → y, z → w}. All attributes take single and atomic values only. A. R
Question



Given a relation scheme R (x, y, z, w) with functional dependencies set F = {x → y, z → w}. All attributes take single and atomic values only.
A. Relation R is in First Normal Form.
B. Relation R is in Second Normal Form.
C. Primary key of R is xz.
Choose the correct answer from the options given below.

A.

C only

B.

B and C only

C.

A and C only

D.

B only

Correct option is C





Thus, A and C only is correct.

Additional Knowledge:
· Statement B: The relation being in 2NF depends on no partial dependency and being in 1NF, which is true here.
· Statement C: xz is correctly identified as the primary key since it uniquely determines all attributes in R(x, y, z, w).

Free Tests

Free
Must Attempt

Basics of Education: Pedagogy, Andragogy, and Hutagogy

languageIcon English
  • pdpQsnIcon10 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon12 Mins
languageIcon English
Free
Must Attempt

UGC NET Paper 1 Mock Test 1

languageIcon English
  • pdpQsnIcon50 Questions
  • pdpsheetsIcon100 Marks
  • timerIcon60 Mins
languageIcon English
Free
Must Attempt

Basics of Education: Pedagogy, Andragogy, and Hutagogy

languageIcon English
  • pdpQsnIcon10 Questions
  • pdpsheetsIcon20 Marks
  • timerIcon12 Mins
languageIcon English

Similar Questions

test-prime-package

Access ‘UGC NET Computer Science’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
383k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow