How would you define second normal form? How do you convert a 1NF design to 2NF? In your answer, refer to specific pages and figures in this chapter.
What will be an ideal response?
To be in second normal form, a record must first be in first normal form and all fields that are not part of the primary key must be dependent on the entire primary key. To convert from 1NF to 2NF, you would create a new record for each field and a possible combination of the fields in the primary key. For each new record, designate one field or combination of fields as a primary key. Place the remaining fields with the primary key on which they depend. When finished placing the fields, discard any record that does not contain any additional fields other than its primary key. The remaining records are the 2NF of the original record. Students should have no difficulty citing specific pages and figures as needed.
You might also like to view...
Of what value are comments that accompany a function declaration?
What will be an ideal response?
The ____ helps you design an on-screen form in which you can enter and manipulate data for each record of a database.
A. Record Wizard B. Form Wizard C. Field Wizard D. Database Wizard
What is the result value of c at the end of the following code segment? int c = 8; c++; ++c; c %= 5;
a. 0. b. 1. c. 3. d. None of the above.
Every class must have a(n) ____________________, and can optionally contain data and methods.
Fill in the blank(s) with the appropriate word(s).