Quiz Lesson III - Data Management Foundations

Quiz Lesson III 1. Proper data warehousing design requires carefully defined and controlled data redundancies to function properly. 2. A(n) _____ is an orderly arrangement used to logically access rows in a table. primary rule superkey relationship index 3. A(n) unique index is an index in which the index key can have only one pointer value (row) associated with it. 4. Rows are sometimes referred to as __________. Files fields records 5. Character data type also known as string data type, can contain any character or symbol not intended for mathematical manipulation, but character sets can include digits or a numeric string. True 6. When you define a table's primary key, the DBMS automatically creates a(n) _____ index on the primary key column(s) you declared. Key Primary Unique Composite 7. The practical significance of taking the logical view is that it serves as a reminder of the simple file concept of data storage. True 8. A primary key is a(n) candidate key selected to uniquely identify all other attribute values in any given row. 9. The one to many (1:M) relationship is easily implemented in the relational model by putting the foreign key of the "1" side in the table of the "many" side as a primary key. False 10. The word relation, also known as a dataset in Microsoft Access, is based on the mathematical set theory from which Codd 11. A _____ key is defined as a key that is used strictly for data retrieval purposes. Secondary Candidate Foreign Lookup 12. In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable. Keys Relations logical structures indexes 13. In a relational table, each column has a specific range of values known as the attribute domain. 14. You can think of a table as a persistent representation of a logical relation. True 15. A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes. Secondary Foreign Primary Candidate 16. As rare as 1:1 relationships should be, certain conditions absolutely require their use. True 17. A table is also called a relation because the relational model's creator, E. F. Codd, used the two terms as __________. Entities Homonyms Synonyms Attributes 18. A table is also called a(n) relation because the relational model's creator, E. F. Codd, used the two terms as synonyms. 19. The _____ relationship is the "relational model ideal." 1:M 1:1 M:N M:1 20. Depending on the sophistication of the application development software, nulls can create problems when functions such as COUNT, AVERAGE, and SUM are used. True 21. A _____ is a key that can uniquely identify any row in the table. candidate key foreign key special key superkey 22. In a relational model keys are also used to establish relationships among tables and to ensure the integrity of the data. 23. The database designer has two main options when defining a composite table's primary key: use the combination of foreign keys or create a new primary key. True 24. A _____ is the primary key of one table that has been placed into another table to create a common attribute. foreign key candidate key composite primary key superkey 25. If one department chair "a professor "can chair only one department, and one department can have only one department chair. The entities PROFESSOR and DEPARTMENT exhibit a 1:1 26. Only a single attribute, not multiple attributes, can define functional dependence. False 27. If the attribute (B) is functionally dependent on a composite key (A) but not on any subset of that composite key, the attribute (B) is fully functionally dependent on (A). True 28. Date attributes contain calendar dates stored in a special format known as the _____ date format. Calendar Julian Logical Epoch 29. A table is perceived as a two-dimensional structure composed of rows and columns. 30. A candidate key is a minimal superkey without any unnecessary attributes. True 31. M:N relationships cannot be implemented as such in the relational model. The _____ relationship should be rare in any relational 32. database design. 1:M 1:1 M:N M:1 33. The _____ constraint can be placed on a column to ensure that every row in the table has a value for that column. EMPTY UNIQUE NOT NULL VALUE 34. An index key can have multiple attributes (a composite index). 35. Each table _____ represents an attribute. Row Dimension Value column 36. The 1:M relationship is the relational database norm. The idea of determination is unique to the database 37. environment. False 38. Referential _____ dictates that the foreign key must contain values that match the primary key in the related table, or must contain null. Model Uniqueness Integrity Attribute 39. The CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of _____ integrity. Null Entity Referential Relational 40. _____ relationships can be implemented by creating a new entity in 1:M relationships with the original entities. 1:N M:1 M:N 1:1 41. RDBMSs enforce integrity rules automatically. True 42. _____ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false. Relational Index Predicate Database 43. One characteristic of generalization hierarchies is that they are implemented as 1:1 relationship. 44. To avoid nulls, some designers use special codes, known as flags, to indicate the absence of some value. 45. Another name for a composite entity is a(n) _____ entity. Linked Directive Logical Bridge 46. Primary keys are required in relational databases to ensure entity integrity. True The proper use of foreign keys is crucial to controlling 47. data redundancy. 48. A null is created when you press the Enter key or the Tab key to move to the next entry without making a prior entry of any kind. True 49. The order of the rows and columns is important to the DBMS. False