True / False

1) ?The process of determining the particular tables and columns that will comprise a database is known as database design.

2. ?A tabular database is a collection of tables.

3. ?A relation is a characteristic or property of an entity.

4. ?Because there is a one-to-many relationship between sales reps and customers in the TAL Distributors database, one sales rep can be associated with zero, one, or more customers.

5. ?In a relational database, each entity has its own table.

6. ?A matrix is the association between entities.

7. ?In the one-to-many type of relationship, the word many always indicates a large number.

8. ?In a relational database, relationships are implemented by having common columns in two or more tables.

9. ?Each column in a table of a relational database should have a distinct name.

10. ?In a relation, all values in a column are values of the same attribute.

11. ?A relation is essentially a three-dimensional table.

12. ?Columns are sometimes called tuples.

13. ?The concept of functional dependence is trivial to understanding database concepts.

14. ?In a relation, the order of the rows and columns is immaterial.

15. ?The same column name can appear in two different tables in a relational database.

16. ?The statement “A sales rep’s pay class functionally determines his or her pay rate” means that if you know the pay class, you can determine the pay rate.

17. ?You can determine functional dependence by viewing sample data.

18. ?A secondary key is the unique identifier for a table.

19. ?A primary key always comprises a single column.

20. ?You can indicate a table’s primary key by underlining the column or collection of columns that comprises the primary key for each table in the database.

21. ?The definition for a primary key really defines a candidate key as well.

22. ?Many organizations and institutions are moving toward using Social Security numbers as primary keys because of privacy issues.

23. ?If a table contained both employee numbers and Social Security numbers, both columns would be referred to as candidate keys.

24. ?A programmer interviews users, examines existing and proposed documents, and examines organizational policies to determine exactly the type of data needs the database must support.

25. ?It is possible for the computer to generate values that are used as the primary key column.

26. ?Normalization is done before creating the database design.

27. ?An unnormalized relation is a relation that may contain repeating groups.

28. ?When you convert an unnormalized table to a table in first normal form, the primary key of the table in first normal form is usually the concatenation of at least two columns.

29. ?Qualification is an update anomaly.

30. ?A table is in third normal form if it is in second normal form and no nonkey column is dependent on only a portion of the primary key.

31. ?A determinant is any column (or collection of columns) that determines another table.

Multiple Choice

32. ?The process of determining the particular tables and columns that will comprise a database is known as ____.

33. ?At TAL Distributors, there is a ____ relationship between sales reps and customers.

34. ?A(n) ____ is the association between entities.

35. ?A(n) ____ is a property of an entity.

36. ?In a relational database each ____ should be unique.

37. ?There is a commonly accepted shorthand representation to show the structure of a relational database: After the name of the table, all the columns in the table are listed within a set of ____.

38. ?A field is another term for a(n) ____.

39. ?A record is another term for a(n) ____.

40. ?Which of the following symbols is used to qualify column names?

41. ?Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE) table?

42. ?A relation is in ____ if it does not contain any repeating groups.

43. ?____ is the formal term for combining two or more columns to form a primary key.

44. ?____ is the duplication of data.

45. ?____ is one of the categories of update anomalies.

46. ?A ____ column is a column that is not part of the primary key.

47. ?____ can occur when there is a column in a table that is dependent on only a portion of the primary key.

48. ?Any column (or collection of columns) that determines another column is called a(n) ____.

49. ?In this text, Boyce-Codd normal form is the same as ____.

50. ?In an entity-relationship (E-R) diagram, ____ are used to represent an entity.

51. ?In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as ____.

Completion

52. ?A(n) ____________________ is a person, place, thing, or event for which you want to store and process data.

53. ?A(n) ____________________ is the association between entities.

54. ?A relationship is an association between ____________________.

55. ?A table’s design should be as simple as possible; you should restrict each position in a table to a single entry by not allowing multiple entries (called a(n) ____________________ group) in an individual location in the table.

56. ?A relational database is a collection of ____________________.

57. ?In a relation, the ____________________ of the rows and columns is immaterial.

58. ?A(n) ____________________ is another name for a record or a row.

59. ?When you combine a column name with a table name, you are said to ____________________ the column name.

60. ?When you write a column  in the format CUSTOMER.REP_NUM, you say that you ____________________ the column name.

61. ?In a relational database, column B is ____________________ on another column A, if at any point in time a value for A determines a single value for B.

62. ?If B is functionally dependent on A, you also can say that A functionally ____________________ B.

63. ?The ____________________ key of a table (relation) is the column or collection of columns that uniquely identifies a given row in that table.

64. ?A relation is in ____________________ normal form if it does not contain any repeating groups.

65. ?The four categories of update anomalies are additions, deletions, inconsistent data, and ____________________.

66. ?A(n) ____________________ column is a column that is not part of the primary key.

67. ?If the primary key of a table contains only a single column, the table is automatically in ____________________ normal form.

68. ?______________________________ is another name given to third normal form in this text.

69. ?In one style of entity-relationship (E-R) diagrams, a crow’s foot is used to represent the ____________________ side of a relationship.

70. ?In one style of entity-relationship (E-R) diagrams, the letter n is used to represent the ____________________ side of a relationship.

71. ?In one style of entity-relationship (E-R) diagrams, diamonds are used to describe ____________________.

Essay

72. ?How does a DBMS that follows the relational model handle entities, attributes of entities, and relationships between entities?

73. ?Define a relation.

74. ?What is the precise definition of a primary key?

75. ?What are the six steps necessary to design a database for a set of requirements?