Technical Interview Questions and Answers :: Accenture
- Select All
- C
- Java
- C++
- .NET
- SQL
- Informatica
- WebMethod
- Soft. Engineering
- Data Structure
- HR Question in TR
- Operating System
- DBMS
131 / 152
A relation schema R is in BCNF if it is in 3NF and satisfies an additional constraint that for every FD X -> A, X must be a candidate key.
132 / 152
A relation schema R is said to be in 4NF if for every Multivalued dependency X ->-> Y that holds over R, one of following is true
> X is subset or equal to (or) XY = R.
> X is a super key.
133 / 152
A Relation schema R is said to be 5NF if for every join dependency {R1, R2, ..., Rn} that holds R, one the following is true
> Ri = R for some i.
> The join dependency is implied by the set of FD, over R in which the left side is key of R.
134 / 152
A relation is said to be in DKNF if all constraints and dependencies that should hold on the constraint can be enforced by simply enforcing the domain constraint and key constraint on the relation.
135 / 152
No Discussion on this question yet!
136 / 152
No Discussion on this question yet!
137 / 152
No Discussion on this question yet!
138 / 152
No Discussion on this question yet!
139 / 152
No Discussion on this question yet!
140 / 152
No Discussion on this question yet!