Access over 20 million homework & study documents

Data Processing Transforming Data Models into Database Designs Quiz

Content type
User Generated
Subject
Databases
Type
Other
Rating
Showing Page:
1/16
1
Copyright © 2010 Pearson Education, Inc.
Database Processing, 11e (Kroenke)
Chapter 6: Transforming Data Models into Database Designs
1) The first step in the database design process is to create tables and columns from entities and
attributes.
Answer: TRUE
Diff: 2 Page Ref: 193 Fig 6-1
2) When creating a relational database design from E-R diagrams, first create a relation for each
relationship.
Answer: FALSE
Diff: 3 Page Ref: 193 Fig 6-1
3) Each entity in the extended E-R model is represented as a table in the relational database
design.
Answer: TRUE
Diff: 1 Page Ref: 193 Fig 6-1
4) An entity needs to be examined according to normalization criteria before creating a table
from it in the relational database design.
Answer: FALSE
Diff: 2 Page Ref: 193, 197 Fig 6-1
5) When creating a table in the relational database design from an entity in the extended E-R
model, the attributes of the entity become the rows of the table.
Answer: FALSE
Diff: 1 Page Ref: 193 Fig 6-1
6) By default, the identifier of the entity becomes the foreign key of the corresponding table.
Answer: FALSE
Diff: 1 Page Ref: 194-195
7) The ideal primary key is short, numeric, and fixed.
Answer: TRUE
Diff: 2 Page Ref: 194
8) A surrogate key is appropriate when the primary key of a table contains a lengthy text field.
Answer: TRUE
Diff: 1 Page Ref: 194
9) One of the important properties of an attribute is whether or not it is required.
Answer: TRUE
Diff: 2 Page Ref: 195
10) Whether or not an attribute is required is determined during the database modeling phase.
Answer: FALSE
Diff: 3 Page Ref: 195

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/16
2
Copyright © 2010 Pearson Education, Inc.
11) A null value is an attribute value that has been set to zero.
Answer: FALSE
Diff: 3 Page Ref: 195
12) Data types are consistent across all DBMS products.
Answer: FALSE
Diff: 1 Page Ref: 196
13) A default value is the value the user enters into the row the first time the user enters data.
Answer: FALSE
Diff: 1 Page Ref: 197
14) A data constraint is a limitation on data values.
Answer: TRUE
Diff: 1 Page Ref: 197
15) The last step in creating a table is to verify table normalization.
Answer: TRUE
Diff: 1 Page Ref: 197 Fig 6-1
16) A foreign key is a key that does not belong in any table.
Answer: FALSE
Diff: 2 Page Ref: 198
17) In a relational database design, all relationships are expressed by creating a foreign key.
Answer: TRUE
Diff: 1 Page Ref: 198
18) When the key of one table is placed into a second table to represent a relationship, the key is
called a "relational key" in the second table.
Answer: FALSE
Diff: 2 Page Ref: 198
19) To represent a 1:1 binary relationship in a relational database design, the key of one table is
placed into the second table.
Answer: TRUE
Diff: 2 Page Ref: 198
20) When placing a foreign key for a 1:1 relationship, the key of either table can be used as the
foreign key in the other table.
Answer: TRUE
Diff: 1 Page Ref: 198
21) In a 1:1 relationship, the foreign key is defined as an alternate key to make the DBMS
enforce uniqueness.
Answer: TRUE
Diff: 2 Page Ref: 199

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/16

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 16 pages?
Access Now
Unformatted Attachment Preview
Database Processing, 11e (Kroenke) Chapter 6: Transforming Data Models into Database Designs 1) The first step in the database design process is to create tables and columns from entities and attributes. Answer: TRUE Diff: 2 Page Ref: 193 Fig 6-1 2) When creating a relational database design from E-R diagrams, first create a relation for each relationship. Answer: FALSE Diff: 3 Page Ref: 193 Fig 6-1 3) Each entity in the extended E-R model is represented as a table in the relational database design. Answer: TRUE Diff: 1 Page Ref: 193 Fig 6-1 4) An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design. Answer: FALSE Diff: 2 Page Ref: 193, 197 Fig 6-1 5) When creating a table in the relational database design from an entity in the extended E-R model, the attributes of the entity become the rows of the table. Answer: FALSE Diff: 1 Page Ref: 193 Fig 6-1 6) By default, the identifier of the entity becomes the foreign key of the corresponding table. Answer: FALSE Diff: 1 Page Ref: 194-195 7) The ideal primary key is short, numeric, and fixed. Answer: TRUE Diff: 2 Page Ref: 194 8) A surrogate key is appropriate when the primary key of a table contains a lengthy text field. Answer: TRUE Diff: 1 Page Ref: 194 9) One of the important properties of an attribute is whether or not it is required. Answer: TRUE Diff: 2 Page Ref: 195 10) Whether or not an attribute is required is determined during the database modeli ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4