Exam 1: Ch 4

2) Data is represented in the form of: A) data trees. B) tables. C) data notes. D) chairs.

Answer: B LO: 4.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology

3) A two-dimensional table of data sometimes is called a: A) group. B) set. C) declaration. D) relation.

Answer: D LO: 4.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology

46) A composite key consists of only one attribute.

Answer: FALSE LO: 4.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology

1) A form of database design which maps conceptual requirements is called: A) logical designs. B) response designs. C) security design. D) physical design.

Answer: A LO: 4.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology

33) Understanding the steps involved in transforming EER diagrams into relations is important because: A) one must be able to check the output of a CASE tool. B) there are rarely legitimate alternatives from which to choose. C) CASE tools can model any situation. D) CASE tools model hypothetical business problems.

Answer: A LO: 4.6: Transform an E-R (or EER) diagram into a logically equivalent set of relations. Difficulty: Moderate Classification: Concept AACSB: Information Technology

24) A candidate key must satisfy all of the following conditions EXCEPT: A) the key must uniquely identify the row. B) the key must indicate the row's position in the table. C) the key must be nonredundant. D) each nonkey attribute is functionally dependent upon it.

Answer: B

4) ________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated. A) Business rule constraint B) Data integrity C) Business integrity D) Data structure

Answer: B LO: 4.1: Define key terms. Difficulty: Moderate Classification: Concept AACSB: Information Technology

22) A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form? A) First B) Second C) Third D) Fourth

Answer: B LO: 4.4: Give a concise definition of each of the following: first normal form, second normal form, and third normal form. Difficulty: Moderate Classification: Concept AACSB: Information Technology

32) An alternative name for an attribute is called a(n): A) synonym. B) alias. C) alternate attribute. D) related characteristic.

Answer: B LO: 4.5: Briefly describe four problems that may arise when merging relations. Difficulty: Moderate Classification: Concept AACSB: Information Technology

35) When a regular entity type contains a multivalued attribute, one must: A) create a single relation with multiple lines for each instance of the multivalued attribute. B) create two new relations, one containing the multivalued attribute. C) create two new relations, both containing the multivalued attribute. D) delete the relation and start over.

Answer: B LO: 4.6: Transform an E-R (or EER) diagram into a logically equivalent set of relations. Difficulty: Difficult Classification: Concept AACSB: Information Technology

5) An attribute (or attributes) that uniquely identifies each row in a relation is called a: A) column. B) foreign field. C) primary key. D) duplicate key.

Answer: C LO: 4.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology

23) A constraint between two attributes is called a(n): A) functional relation. B) attribute dependency. C) functional dependency. D) functional relation constraint.

Answer: C LO: 4.4: Give a concise definition of each of the following: first normal form, second normal form, and third normal form. Difficulty: Moderate Classification: Concept AACSB: Information Technology

34) A nonkey attribute is also called a(n): A) column. B) unimportant datum. C) descriptor. D) address.

Answer: C LO: 4.6: Transform an E-R (or EER) diagram into a logically equivalent set of relations. Difficulty: Moderate Classification: Concept AACSB: Information Technology

43) ________ anomalies can be caused by editing data in tables. A) Insertion B) Deletion C) Modification D) Creation

Answer: C LO: 4.7: Create relational tables that incorporate entity integrity and referential integrity constraints. Difficulty: Moderate Classification: Concept AACSB: Information Technology

44) A relation that contains minimal redundancy and allows easy use is considered to be: A) clean. B) simple. C) complex. D) well-structured.

Answer: D LO: 4.7: Create relational tables that incorporate entity integrity and referential integrity constraints. Difficulty: Easy Classification: Concept AACSB: Information Technology

65) An identifier assigned to an associative entity is also called a cross-relation key.

Answer: FALSE LO: 4.6: Transform an E-R (or EER) diagram into a logically equivalent set of relations. Difficulty: Difficult Classification: Concept AACSB: Information Technology

62) The primary key of the many side migrates to the one side when transforming a one-to-many relationship.

Answer: FALSE LO: 4.6: Transform an E-R (or EER) diagram into a logically equivalent set of relations. Difficulty: Moderate Classification: Concept AACSB: Information Technology

63) When transforming a one-to-one relationship, a new relation is always created.

Answer: FALSE LO: 4.6: Transform an E-R (or EER) diagram into a logically equivalent set of relations. Difficulty: Moderate Classification: Concept AACSB: Information Technology

85) Anomalies do not generally arise out of transitive dependencies.

Answer: FALSE LO: 4.8: Use normalization to decompose a relation with anomalies into well-structured relations. Difficulty: Difficult Classification: Concept AACSB: Information Technology

82) A relation is in first normal form if it has no more than one multivalued attribute.

Answer: FALSE LO: 4.8: Use normalization to decompose a relation with anomalies into well-structured relations. Difficulty: Easy Classification: Concept AACSB: Information Technology

80) A co-dependency is a constraint between two attributes or two sets of attributes.

Answer: FALSE LO: 4.8: Use normalization to decompose a relation with anomalies into well-structured relations. Difficulty: Moderate Classification: Concept AACSB: Information Technology

45) Data structures include data organized in the form of tables with rows and columns.

Answer: TRUE LO: 4.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology

47) A primary key is an attribute that uniquely identifies each row in a relation.

Answer: TRUE LO: 4.1: Define key terms. Difficulty: Easy Classification: Concept AACSB: Information Technology

64) If an identifier is not assigned, the default primary key for an associative relation consists of the two primary key attributes from the other two relations.

Answer: TRUE LO: 4.6: Transform an E-R (or EER) diagram into a logically equivalent set of relations. Difficulty: Moderate Classification: Concept AACSB: Information Technology

81) A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation.

Answer: TRUE LO: 4.8: Use normalization to decompose a relation with anomalies into well-structured relations. Difficulty: Easy Classification: Concept AACSB: Information Technology