database-the-relational-model-and-normalization Related Question Answers

1. Which of the following is a group of one or more attributes that uniquely identifies a row?





2. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):





3. A relation is considered a:





4. In the relational model, relationships between relations or tables are created by using:





5. A functional dependency is a relationship between or among:





6. Table is synonymous with the term:





7. Which of the following is not a restriction for a table to be a relation?





8. For some relations, changing the data can have undesirable consequences called:





9. A key:





10. An attribute is a(n):





11. A relation in this form is free of all modification anomalies.





12. If attributes A and B determine attribute C, then it is also true that:





13. A tuple is a(n):





14. If attribute A determines both attributes B and C, then it is also true that:





15. One solution to the multivalued dependency constraint problem is to:





16. In a relation, the order of the rows matters.



17. In a relation, the rows are sometimes called "records."



18. Any table that meets the definition of a relation is said to be in first normal form.



19. Given the functional dependency R → (S,T) , then it is also true that R → S.



20. A candidate key is a determinant that determines all the other columns is a relation.



21. The only reason for the existence of relations is to store instances of functional dependencies.



22. A relation is in 5NF when multivalued dependencies are isolated in their own relation.



23. The functional dependency R → S means that the value of S can be determined when we are given a value of R.



24. In a relation, the columns are sometimes called "attributes."



25. In a relation, the order of the columns does not matter.



Terms And Service:We do not guarantee the accuracy of available data ..We Provide Information On Public Data.. Please consult an expert before using this data for commercial or personal use | Powered By:Omega Web Solutions
© 2002-2017 Omega Education PVT LTD...Privacy | Terms And Conditions
Question ANSWER With Solution