Let R(A, B, C, D, E, P, G) be a relational schema in which the following…

PYQ AMCAT 2025

Let R(A, B, C, D, E, P, G) be a relational schema in which the following functional dependencies are known to hold:

  • AB → CD

  • DE → P

  • C → E

  • P → C

  • B → G

The relation schema R is ______.

  1. A.

    In Boyce-Codd normal form

  2. B.

    In third normal form, but not in Boyce-Codd normal form

  3. C.

    In second normal form, but not in third normal form

  4. D.

    Not in second normal form

Attempted by 302 students.

Sign up free to check your answer

Sign up free

Explore the full course: Amcat Preparation

Loading lesson…