1. The denormalized design of a JSON document implies a violation of thed lsioin
ID: 3710960 • Letter: 1
Question
1. The denormalized design of a JSON document implies a violation of thed lsiointness constraint. b. fifth normal form. c. first normal form. d. XML well-formedness. 2. A query tree represents the order of execution of a query block that a. starts at the left child of the root. b. starts at the leaf nodes and ends at the root. c. starts at the right child of the root.e d. starts at the root and ends at the leaf nodes. 3. Relation fA,B,C) is not in 3NF if its FDs ared a. A-> B and B-> A.e b. A-> B and C-> B. c. A-> C and B-> C. d. A-> B and B-> C. 4. A secondary index provides a. an inverted index. b. external hashing. professor. student. (student, professor) -> course.* professor -> (course, studenty.Explanation / Answer
1. c, when we denormalise a normalised JSON document we invite back the duplicacies in a table, which violates the 1st normal form.
2. b, A query tree represents the input relations of the query as leaf node and the relational algebra operations as internal nodes, thus execution starts from leaf and end at the root node.
3. d, the given FD A-> B, B-> C, represents transitiveness, which is to be eliminated if a table is in 3NF.
4, c. A secondary index is an index created on the most frequently used dimensions in a table.
5. a, A query tree is a representation of select statement.
6. b, a student can uniquely defined by his course and his teacher.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.