Critical Thinking Questions
Case 11-2
?
An employee at PrattLast Associates is using the normalization process to analyze her database design.
?
She has created the following Account table:
?
Account (Product, Audience, CompanyCode, CompanyName)
How can she convert this table to a table in 3NF? For each determinant that is not a candidate key, remove from the table the fields that depend on this determinant, but do not remove the determinant. Next, create a new table containing all the fields from the original table that depend on this determinant.
a. Finally, make the candidate key the primary key of this new table. b. Finally, make the determinant the primary key of this new table. c. Finally, make all remaining determinants dependent on nonkeys. d. Finally, make the determinant a nonkey.
What will be an ideal response?
Answer: B
You might also like to view...
When you hold down the CTRL key while rolling the mouse wheel, text on the screen may become larger or smaller based on the direction you roll the wheel.
Answer the following statement true (T) or false (F)
Guidelines for developing a prototype are:
What will be an ideal response?
In a typical word processing program, a footer is text entered by the user that appears at the top of every page.
Answer the following statement true (T) or false (F)
Which of the following is true about Entity-Relationship Diagrams, or ERDs?
What will be an ideal response?