hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    arrow
    arrow
    arrow
    In a schema R (A, B, C, D, E, F, G, H), each field of R contains only atomic values. F = {CH→ G, A → BC, B→CFH, E→A, F→EG} is a set of functional de
    Question



    In a schema R (A, B, C, D, E, F, G, H), each field of R contains only atomic values.
    F = {CH→ G, A → BC, B→CFH, E→A, F→EG} is a set of functional dependencies so that F + is exactly the set of FDs that holds R. The relation R is.

    A.

    In 1 NF, but not in 2NF

    B.

    In 2NF, but not in 3NF

    C.

    In 3NF, but not in BCNF

    D.

    In BCNF

    E.

    None of the above

    Correct option is A

    The schema provided is in 1NF (First Normal Form) because all fields contain atomic values (no repeating groups or nested records). However, it does not meet the conditions for 2NF (Second Normal Form) as partial dependencies still exist. Partial dependencies occur when non-prime attributes are dependent on a part of a candidate key rather than the whole key.
    Important Key Points:
    1. First Normal Form (1NF): Ensures that all values in a table are atomic and no repeating groups exist.
    2. Second Normal Form (2NF): A relation is in 2NF if it is in 1NF and there are no partial dependencies.
    3. Functional Dependencies: Partial dependencies arise when attributes are dependent on only part of a composite key.
    Knowledge Booster:
    · Third Normal Form (3NF) requires no transitive dependencies. This schema does not reach this stage as there are partial dependencies.
    · BCNF (Boyce-Codd Normal Form): A relation is in BCNF if every determinant is a candidate key, which is more restrictive than 3NF.

    Free Tests

    Free
    Must Attempt
    Video Solutions

    RBI Assistant Pre 2026 Full Mock Test -01

    languageIcon English
    • pdpQsnIcon100 Questions
    • pdpsheetsIcon100 Marks
    • timerIcon60 Mins
    languageIcon English
    Free
    Must Attempt
    Video Solutions

    RBI Asst Prelims 2026 : Reasoning Section Test 01

    languageIcon English
    • pdpQsnIcon35 Questions
    • pdpsheetsIcon35 Marks
    • timerIcon20 Mins
    languageIcon English
    Free
    Must Attempt
    Video Solutions

    RBI Office Attendant 2026 Full Mock Test - 01

    languageIcon English
    • pdpQsnIcon120 Questions
    • pdpsheetsIcon120 Marks
    • timerIcon90 Mins
    languageIcon English
    test-prime-package

    Access ‘IBPS SO IT Officer’ 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