Chapter 4 Review

12) The entity integrity rule states that: A) no primary key attribute can be null. B) referential integrity must be maintained across all entities. C) each entity must have a primary key. D) a primary key must have only one attribute.

A

15) A rule that states that each foreign key value must match a primary key value in the other relation is called the: A) referential integrity constraint. B) key match rule. C) entity key group rule. D) foreign/primary match rule.

A

19) Understanding the steps involved in transforming EER diagrams into relations is important because: A) you 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) none of the above.

A

29) When all multivalued attributes have been removed from a relation, it is said to be in: A) first normal form. B) second normal form. C) Boyce-Codd normal form. D) third normal form.

A

41) An attribute that may have more than one meaning is called a(n): A) homonym. B) alias. C) double defined attribute. D) synonym.

A

1) A form of database specification that indicates all the parameters for data storage that are then input to database implementation is: A) logical. B) physical. C) schematic. D) conceptual.

B

14) The ________ states that no primary key attribute may be null. A) referential integrity constraint B) entity integrity rule C) partial specialization rule D) range domain rule

B

16) In the SQL language, the ________ statement is used to make table definitions. A) create session B) create table C) create index D) select

B

21) 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) none of the above.

B

31) The normal form which deals with multivalued dependencies is called: A) Fifth normal form. B) Fourth normal form. C) Boyce-Codd normal form. D) Sixth normal form.

B

32) 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

B

34) 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.

B

35) The attribute on the left-hand side of the arrow in a functional dependency is the: A) candidate key. B) Determinant. C) foreign key. D) primary key.

B

36) A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a __________ dependency. A) partial key-based B) partial functional C) cross key D) merged relation

B

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

B

5) ________ 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

B

8) A primary key that consists of more than one attribute is called a: A) foreign key. B) composite key. C) multivalued key. D) cardinal key.

B

11) Which of the following is NOT a reason to create an instance of a relational schema with sample data? A) Sample data can be used to improve user communications. B) Sample data can be used for prototype generation. C) Sample data can reverse database implementation errors. D) Sample data provide a convenient way to check the accuracy of your design.

C

13) A domain definition consists of the following components EXCEPT: A) domain name. B) data type. C) integrity constraints. D) size.

C

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

C

28) All of the following are the main goals of normalization EXCEPT: A) minimize data redundancy B) simplify the enforcement of referential integrity C) maximize storage space D) make it easier to maintain data

C

30) The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called: A) Fifth normal form. B) Fourth normal form. C) Boyce-Codd normal form. D) Sixth normal form.

C

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

C

37) A functional dependency between two or more nonkey attributes is called a: A) partial functional dependency. B) partial nonkey dependency. C) transitive dependency. D) partial transitive dependency.

C

40) Two or more attributes having different names but the same meaning are called: A) homonyms. B) aliases. C) synonyms. D) alternate attributes.

C

43) A primary key whose value is unique across all relations is called a(n): A) global primary key. B) inter-table primary key. C) enterprise key. D) foreign global key.

C

6) 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.

C

7) An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a: A) link attribute. B) link key. C) foreign key. D) foreign attribute

C

17) Which of the following are anomalies that can be caused by redundancies in tables? A) Insertion B) Deletion C) Modification D) All of the above

D

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

D

2) Physical database design decisions must be made carefully because of impacts on: A) data accessibility. B) response times. C) security. D) all of the above.

D

3) The relational data model consists of which components? A) Data structure B) Data manipulation C) Data integrity D) All of the above

D

38) Which of the following anomalies result from a transitive dependency? A) Insertion B) Modification C) Deletion D) All of the above

D

39) An understanding of how to merge relation is important because: A) there may be a need to merge relations on projects with subteams. B) different views may need to be integrated. C) new data requirements may produce new relations to be merged. D) all of the above.

D

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

D

9) Which of the following are properties of relations? A) Each attribute has a unique name. B) No two rows in a relation are identical. C) There are no multivalued attributes in a relation. D) All of the above.

D