Critical Thinking Questions
Case 11-1
?
One of the employees at PrattLast Associates is attempting to use the normalization process in the design of the database. She has created the following unnormalized table:
?
Account (Product, Audience, CompanyCode, CompanyName, (AccountNum, AccountLast, AccountFirst))
How can she convert this unnormalized table to a table in first normal form?
a. Remove the parentheses enclosing the repeating group and expand the primary key to include the key to the repeating group. b. Add brackets around the group to not enclosed and keep the parentheses. c. Move the parentheses so that the AccountNum is not included. d. Put parentheses around each key.
What will be an ideal response?
Answer: A
You might also like to view...
Consider an existing game of bridge written in Java. We are interested in integrating this bridge game into ARENA. Which design pattern would you use? Draw a UML class diagram relating the ARENA objects with some of the classes you would expect to find in the bridge game.
What will be an ideal response?
A(n) ________ second is added to clocks to allow for inconsistencies between the Earth's rotation and the time recorded by our everyday devices
a. Atomic b. Nano c. IP d. Leap
Without the visual impact of ____, Web pages are neither interesting nor motivating.
a. color b. contrast c. shapes d. all of the above
Match each item with the correct statement below.
A. Transmits a single digital signal B. Networks in a metropolitan geographical area such as a town or city C. Networks in homes, office buildings, health care facilities, or on college campuses D. Uses multiple channels of data E. Networks for very large geographical areas such as a state