hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    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
    354k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow