Explain Multivalued dependency?
Submitted by: AdministratorMultivalued dependency denoted by X-->Y specified on relation schema R, where X and Y are both subsets of R, specifies the following constraint on any relation r of R: if two tuples t1 and t2 exist in r such that t1[X] = t2[X] then t3 and t4 should also exist in r with the following properties
► t3[x] = t4[X] = t1[X] = t2[X]
► t3[Y] = t1[Y] and t4[Y] = t2[Y]
► t3[Z] = t2[Z] and t4[Z] = t1[Z]
where [Z = (R-(X U Y)) ]
Submitted by: Administrator
► t3[x] = t4[X] = t1[X] = t2[X]
► t3[Y] = t1[Y] and t4[Y] = t2[Y]
► t3[Z] = t2[Z] and t4[Z] = t1[Z]
where [Z = (R-(X U Y)) ]
Submitted by: Administrator
Read Online Operational Data Store Job Interview Questions And Answers
Top Operational Data Store Questions
| ☺ | Explain Multivalued dependency? |
| ☺ | Explain How does Tuple-oriented relational calculus differ from domain-oriented relational calculus? |
| ☺ | What is operational data store? |
| ☺ | Tell me what is degree of a Relation? |
| ☺ | Explain normalization? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
