###### Database-Management-System

August 29, 2024###### Database-Management-System

August 29, 2024# Database-Management-System

Question 820 |

**For a database relation R(a, b, c, d) where the domains of a, b, c and d include only atomic values, and only the following functional dependencies and those that can be inferred from them hold :**

- a → c

b → d

The relation is in

First normal form but not in second normal form
| |

Second normal form but not in third normal form | |

Third normal form
| |

BCNF |

**Question 820 Explanation:**

**Primary key of given relation is “ab”.**

And there is a partial dependency exist in given FD’s so the given relation is in 1NF but not in second normal form.

And there is a partial dependency exist in given FD’s so the given relation is in 1NF but not in second normal form.

Correct Answer: A

**Question 820 Explanation:**

**Primary key of given relation is “ab”.**

And there is a partial dependency exist in given FD’s so the given relation is in 1NF but not in second normal form.

And there is a partial dependency exist in given FD’s so the given relation is in 1NF but not in second normal form.

Subscribe

Login

0 Comments