1. The entity integrity rule states that: A. no primary key attribute may be null. B. no primary key can be composite. C. no primary key may be unique. D. no primary key may be equal to a value in a foreign key. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
2. When mapping a many-to-many unary relationship into a relation which of the following is true? A. One relation is created. B. Two relations are created. C. Three relations are created. D. Four relations are created. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
3. If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form? A. First normal form B. Second normal form C. Third normal form D. Fourth normal form Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
4. A foreign key is which of the following? A. Any attribute B. The same thing as a primary key C. An attribute that serves as the primary key of another relation D. An attribute that serves no purpose Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option C No explanation is given for this question Let's Discuss on Board
5. A transitive dependency is which of the following? A. A functional dependency between two or more key attributes. B. A functional dependency between two or more nonkey attributes. C. A relation that is in first normal form. D. A relation that is in second normal form. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
6. When mapping a multivalued attribute into a relation which of the following is true? A. One relation is created. B. Two relations are created. C. Three relations are created. D. Four relations are created. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
7. If no multivalued attributes exist in a relation, then the relation is in what normal form? A. First normal form B. Second normal form C. Third normal form D. Fourth normal form Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
8. A primary key is which of the following? A. Any attribute B. An attribute that uniquely identifies each row C. An attribute that uniquely identifies each column D. A derived attribute Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option B No explanation is given for this question Let's Discuss on Board
9. The relational model consists of: A. data in the form of tables. B. data redundancy. C. operations using non-SQL languages. D. unorganized data. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option A No explanation is given for this question Let's Discuss on Board
10. When mapping a binary many-to-many relationship into a relation which of the following is true? A. One relation is created. B. Two relations are created. C. Three relations are created. D. Four relations are created. Answer & Solution Discuss in Board Save for Later Answer & Solution Answer: Option C No explanation is given for this question Let's Discuss on Board