Student Student ID Major Name Course No. Section No. Course Name Instructor No. Instructor Instructor Name Phone No. Grade 2NF Tables: The Whole Key Remove Partial Dependencies 86432 Jones Accounting AOC315 517-001 Inter Financial Accounting 456-001 Ray 858-4545 A 86432 Jones Accounting AOC324 F17-001 Cost Accounting 521-121 Sees 858-4578 A 86432 Jones Accounting MAT211 F17001 Calculus 326 987 Billings 858-2391 B 86432 Jones Accounting AOC301 F17-001 Accounting Ethics 456-001 Ray 858-4545 A 86789 Archer Management MGT123 F17-002 Intro to Management 525-888 Buell 858-6587 C 86789 Archer Management HIS111 F17-001 U.S. History 627-856 Patch 858-7771 B 86789 Archer Management MKT101 $17-002 Intro to Marketing 557-889 Phillips 858-3216 E 86789 Archer Management MKT101 F17-001 Intro to Marketing 557-889 Phillips 858-3216 C 98653 Ward Accounting A0C101 F17-003 Intro to Financial Accounting 456-001 Ray 858-4545 B 3NF Tables: Nothing but the key Remove Transient Dependencies 98653 Ward Accounting MAT211 $17-002 Calculus 326-987 Billings 858-2391 E 98653 Ward Accounting MAT211F17-002 Calculus 445-517 Delavan 858-1256 C 98653 Ward Accounting MGT123 F17-00Z Intro to Management 525-888 Buell 858-6587 B 45455 Smith Finance AOC101 F17-005 Intro to Financial Accounting 222-547 Taggert 858-9921 B Green line test: verify cach table is related (linked) to at least one other table. Enter the final set of 3NF tables for class activity example 2 (Student Roster example) into the answer grid below. DO NOT enter any 1NF or 2NF tables into the answer grid. Each 3NF table in your solution should be entered into a single and separate row in the grid. Primary keys should be entered into cells in the column labeled Primary Key. If a primary key is comprised of multiple attributes (e.g., a dual primary key), enter all components of the key into the same cell (component parts should be separated by a comma). Each non-key attribute in a given table should be entered into its own cell in one of the columns labeled Attribute. Do not delete the answer grid. Do not add or delete columns or row from the answer grid. The answer grid may contain unneeded rows/cells. All unneeded rows/cells should be left blank. 3NF Primary Attribute Attribute Attribute Attribute Attribute Attribute Table 1 2 3 4 5 6 Student Student ID Major Name Course No. Section No. Course Name Instructor No. Instructor Instructor Name Phone No. Grade 2NF Tables: The Whole Key Remove Partial Dependencies 86432 Jones Accounting AOC315 517-001 Inter Financial Accounting 456-001 Ray 858-4545 A 86432 Jones Accounting AOC324 F17-001 Cost Accounting 521-121 Sees 858-4578 A 86432 Jones Accounting MAT211 F17001 Calculus 326 987 Billings 858-2391 B 86432 Jones Accounting AOC301 F17-001 Accounting Ethics 456-001 Ray 858-4545 A 86789 Archer Management MGT123 F17-002 Intro to Management 525-888 Buell 858-6587 C 86789 Archer Management HIS111 F17-001 U.S. History 627-856 Patch 858-7771 B 86789 Archer Management MKT101 $17-002 Intro to Marketing 557-889 Phillips 858-3216 E 86789 Archer Management MKT101 F17-001 Intro to Marketing 557-889 Phillips 858-3216 C 98653 Ward Accounting A0C101 F17-003 Intro to Financial Accounting 456-001 Ray 858-4545 B 3NF Tables: Nothing but the key Remove Transient Dependencies 98653 Ward Accounting MAT211 $17-002 Calculus 326-987 Billings 858-2391 E 98653 Ward Accounting MAT211F17-002 Calculus 445-517 Delavan 858-1256 C 98653 Ward Accounting MGT123 F17-00Z Intro to Management 525-888 Buell 858-6587 B 45455 Smith Finance AOC101 F17-005 Intro to Financial Accounting 222-547 Taggert 858-9921 B Green line test: verify cach table is related (linked) to at least one other table. Enter the final set of 3NF tables for class activity example 2 (Student Roster example) into the answer grid below. DO NOT enter any 1NF or 2NF tables into the answer grid. Each 3NF table in your solution should be entered into a single and separate row in the grid. Primary keys should be entered into cells in the column labeled Primary Key. If a primary key is comprised of multiple attributes (e.g., a dual primary key), enter all components of the key into the same cell (component parts should be separated by a comma). Each non-key attribute in a given table should be entered into its own cell in one of the columns labeled Attribute. Do not delete the answer grid. Do not add or delete columns or row from the answer grid. The answer grid may contain unneeded rows/cells. All unneeded rows/cells should be left blank. 3NF Primary Attribute Attribute Attribute Attribute Attribute Attribute Table 1 2 3 4 5 6
