GATE | IT | 2008 | DBMS | Functional dependency |Question 60 (original) (raw)

• Courses

• Tutorials

• Interview Prep

• DSA

• Practice Problems

• C

• C++

• Java

• Python

• JavaScript

• Data Science

• Machine Learning

• Courses

• Linux

• DevOps

Last Updated :

Discuss

Comments

Let R (A, B, C, D, E, P, G) be a relational schema in which the following functional depen­dencies are known to hold: AB → CD, DE → P, C → E, P → C and B → G. The relational schema R is

in BCNF

in 3NF, but not in BCNF

in 2NF, but not in 3NF

not in 2NF

This question is part of this quiz :

Database Design(Normal Forms),

Gate IT 2008

Tags:

DBMS Quiz

GATE

Share your thoughts in the comments

GeeksforGeeks