###### Database-Management-System

October 14, 2023###### Database-Management-System

October 14, 2023# Database-Management-System

Question 14 |

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

a → c b → d

This relation is

in first normal form but not in second normal form | |

in second normal form but not in third normal form | |

in third normal form | |

None of the above |

Question 14 Explanation:

Candidate key is ab.

Since all a, b, c, d are atomic. So the relation is in 1NF.

Checking the FD’s

a → c

b → d

We can see that there is partial dependencies. So it is not 2NF.

So answer is option (A).

Since all a, b, c, d are atomic. So the relation is in 1NF.

Checking the FD’s

a → c

b → d

We can see that there is partial dependencies. So it is not 2NF.

So answer is option (A).

Correct Answer: A

Question 14 Explanation:

Candidate key is ab.

Since all a, b, c, d are atomic. So the relation is in 1NF.

Checking the FD’s

a → c

b → d

We can see that there is partial dependencies. So it is not 2NF.

So answer is option (A).

Since all a, b, c, d are atomic. So the relation is in 1NF.

Checking the FD’s

a → c

b → d

We can see that there is partial dependencies. So it is not 2NF.

So answer is option (A).

Subscribe

Login

0 Comments