9 The following is a table of the data for a database system with its field names and example of the values in each field. The example data contains 4 records. The table is not normalized. Invoice# Invoice Date Order Date CustID Item# Description Price Qty Co. 5701 06/09/97 06/05/97 3001 112 Printer $48.70 6 B Co. Phone 555-1233 Contact Roger Gee 5701 06/09/97 06/05/97 3001 122 Router $25.10 10 5702 06/12/97 06/09/97 3006 129 Switch $12.84 18 B Co. A Co. 555-1233 268-6457 Roger Gee Jane Dil 5702 06/12/97 06/09/97 3006 112 Printer $48.70 14 A Co. 268-6457 Jane Dil Put table in Third normal form. List the table names for each table using ALL CAPS. List all the attributes (fields) in each table using lower case letters. Identify the key field or fields in each table by underlining the particular field. Also show foreign key relationships between the tables with an arrow. If you want to do it in steps by putting it in First Normal form, then second normal form and then third normal form you may do so. But be sure to label your Third normal form answer. I suggest that you design and label your tables with their fields (attributes), primary key field(s), and foregn key relationships on paper before you complete the multiple response questions. A multiple response question (labeled "Choose all that apply") has at least one correct letter selection, but the correct answer may require selecting more than one correct letter. Also some questions are worth more points than others. The definitions of the normal forms are given below: First Normal Form (1NF) contains no one to many relationships from the key to nonkey fields (no repeating groups.) Second normal form (2NF) takes 1NF and makes sure that all attributes are determined by a full key (not a partial key) in any given table. 3NF adds to this by eliminating all transitive dependencies (a nonkey field does not determine any other nonkey field) within any table. How many tables should there be to satisfy for 3rd normal form for all this data? (2 points) 3 5 1