SOLVED

 16)In the ________ normal form of the normalization process, not all data redundancy is eliminated but partial functional dependencies are not allowed. a.First b.Second c.Third d.Fourth 17)In the __________ normal form of the normalization process, the data file is completely free of data redundancy and all foreign keys appear where needed to link related tables. a.First b.Second c.Third d.Fourth 18)Evaluating the following table, this data file appears to be in the ________ form of the normalization process. a.First b.Second c.Third d.nonnormalized  Student ID Start Date Student Name Student Address Class ID Class Name 12345 8/2015 John Smith 123 W. Elm St. MIS123 Intro to Databases     MIS200 Intermediate MIS     MIS205 Project Mgmt 13579 8/2016 Jane Doe 456 Main St. MIS100 Intro to MIS     MIS123 Intro to Databases     MIS156 Intro to Org Systems  19)Evaluating the following table, this data file appears to be in the ________ form of the normalization process. a.First b.Second c.Third d.nonnormalized  Student ID Start Date Student Name Student Address Class ID Class Name 12345 8/2015 John Smith 123 W. Elm St. MIS123 Intro to Databases 12345 8/2015 John Smith 123 W. Elm St. MIS200 Intermediate MIS 12345 8/2015 John Smith 123 W. Elm St. MIS205 Project Mgmt 13579 8/2016 Jane Doe 456 Main St. MIS100 Intro to MIS 13579 8/2016 Jane Doe 456 Main St. MIS123 Intro to Databases 13579 8/2016 Jane Doe 456 Main St. MIS156 Intro to Org Systems  20)Evaluating the following tables, this data file appears to be in the ________ form of the normalization process. a.First b.Second c.Third d.nonnormalized  Student ID Start Date Student Name Student Address  Class ID Class Name 12345 8/2015 John Smith 123 W. Elm St. MIS123 Intro to Databases 12345 8/2015 John Smith 123 W. Elm St. MIS200 Intermediate MIS 12345 8/2015 John Smith 123 W. Elm St. MIS205 Project Mgmt 13579 8/2016 Jane Doe 456 Main St. MIS100 Intro to MIS 13579 8/2016 Jane Doe 456 Main St. MIS123 Intro to Databases 13579 8/2016 Jane Doe 456 Main St. MIS156 Intro to Org Systems  Â