How would you define third normal form? How do you convert a 2NF design to 3NF? In your answer, refer to specific pages and figures in this chapter.
What will be an ideal response?
A record is in third normal form if it is in second normal form and if no nonkey field is dependent on another nonkey field. To convert a record to 3NF you would move the dependent field to a new record, which has the field it is dependent on as the primary key.
You might also like to view...
Which exception will the following code generate?
``` Dim str As String str = "isual Basic'Substring(14,2) ``` (A) NullReferenceException (B) ArgumentOutOfRangeException (C) OverflowException (D) InvalidCastException
Any field declared with keyword ________ is constant.
a. static b. const c. constant d. final
For the user to know what values are to be entered at the right time, the instruction, or prompt, must be displayed onscreen.
Answer the following statement true (T) or false (F)
The Math class is a part of the ____ package, so it need not be imported using the import statement.
A. java.util B. java.lang C. java.awt D. javax.swing