GATE 2022: Database Management system Quiz-8

A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

In an entity relationship there are two entities A and B,

A is dominant entity

B is subordinate entity

Which of the following is correct?

Select the correct statement. [Multiple Select Question]

1. If the every candidate key of relational schema R is simple candidate keys then relation ‘R’ always in the 2NF but may or may not be in 3 NF.
2. If the every candidate key is a simple candidate key then the partial dependencies possible.
3. If the every attribute of relation R is prime attribute then the relation R is always in 3NF but may not be in BCNF.

The order of an internal node in a B+ tree index is the maximum number of children it can have. Suppose that a child pointer can takes 6 Bytes, the search field value takes 14 Bytes and the block size is 512 Bytes. What is the order of internal node?

Given a set of functional dependencies on R (A, B, C, D, E) find number of candidate keys?

A -> B

BC -> E

DE -> A