Hi guys, The first picture is the assignment instructions, second is the Flat File, & the last two are my answers which I have been asked to redo.

Chapter 4 Assignment You have been hired to review the accuracy of the books of Northeast Seasonal Jobs International (NSJI), a job broker. NS matches employers whose business is seasonal (like ski resorts) with people looking for part time positions at such places. Employers are located in the Northeast (New England), but recently expanded to include parts of Canada. NSJI maintains all of this information in a flat file spreadsheet. For the spreadsheet structure see the Excel file "Student_NSJI_Flat File.xlsx" attached. Requirements 1) From a reviewer's perspective, explain what is wrong with NSJI's approach to manage its data. Do you think these problems are serious from the company perspective? Please be specific. 2) To reduce the possible impact of these potential problems, what advice would you give to the company? 3) Using the spreadsheet structure provided, transform the flat file to 3NF (third normal form) Business Rules You have ascertained from an interview with your client (NSJI) * Contact position is fixed - does not change (i.e. it is a field of Employer) "Comments" is a field of Employer, not Position . "NAICS" stands for "North American Industry Classification System" "Openings" is a field of Position, not Employer "Phone" is a field of Employer * "Position ID" is unique for all employers Hints for HW4 Posted on: Wednesday, January 23, 2019 12:37:55 PM EST Hello ACC 421 Online Students, This email provides some hints for you to complete Homework 4 First, you need to understand what this spreadsheet wants to tell you. Although there are many columns, the main takeaway from this spreadsheet is that "certain employers want certain numbers of certain positions to be filled". Once this is clear, you know you need a "main table" which only consists of three columns: Employer ID, Position ID, and Openings, while all the other columns in the big spreadsheet just serve as additional information for either Employer ID or Position ID. For example, Employer Name explains employer's name by the ID number, Address explains employer's address, NAICS Code explains the industry the employer lies in, and so on. Similarly, Position Title, Wage, Hrs/Wk etc. are additional information for Position_ID. Therefore, you need to have two other tables with these pieces of additional information, like this: Employer Information Table Employer ID, Employer Name, Address, City,... etc. Position Information Table Position _ID, Position Title, Wage, Hrs/Wk, . etc. Now you have three tables: the main table, employer table, and position table. Pay attention, NAICS Code and NAICS_Description are repeated information, i.e. they can explain each other, so they cannot be in the same table for the purpose of 3NF. Therefore, you can leave either one of them in the employer table, and start a new table which only consists of NAICS_ Code and NAICS Description. This table only explains each code with the description. In conclusion, you will have four tables for HW4. If you have further question, please do not h Best regards, Kelvin esitate to e NAIKS_Descript on PositionTitie wage Hrs/W Experience tart Dste End_Dene lopemings NA 2o USA 58152 oie Maroe 42 Toar Cuide ryter round. Employee regnet bstsertin Engen yser roua. Enpkyses reed nat be tuertin Englis. 7 Vinayerd Heve RackpertN4 319 USA 121191 Bei-end-Breekfe: Cre Fersorel Vanege 97254193 2227 e978548319928 236 Resvtist 14.75 10 North Conway NH 306 yeer round. Erployee% reed not be Enger, speekrg Director's st rare 5 pronounced "Buh TRAY tis 5023892737 2115 facp Ckrk 13.0 25 2120 t Shop Clerk 13.50 1332 kin Facies Personrel ianege 8022539*Ftral inted-ervice Resteuraris Vicon Daceo 8036358 2580 1382 sngcs 1382 Skng Feces 6002868233 20 Dy tare 4198374745 202 Cok 191 Bed-and-greailast ins 130 32 11 ect-and-Ereaklasti 024848354 20 HalHaa70 4 Eviel wa CY NL Event S Mail che roll Cler o mbined Payrell Cler dil traive er ith Chapter 4 Assignment You have been hired to review the accuracy of the books of Northeast Seasonal Jobs International (NSJI), a job broker. NS matches employers whose business is seasonal (like ski resorts) with people looking for part time positions at such places. Employers are located in the Northeast (New England), but recently expanded to include parts of Canada. NSJI maintains all of this information in a flat file spreadsheet. For the spreadsheet structure see the Excel file "Student_NSJI_Flat File.xlsx" attached. Requirements 1) From a reviewer's perspective, explain what is wrong with NSJI's approach to manage its data. Do you think these problems are serious from the company perspective? Please be specific. 2) To reduce the possible impact of these potential problems, what advice would you give to the company? 3) Using the spreadsheet structure provided, transform the flat file to 3NF (third normal form) Business Rules You have ascertained from an interview with your client (NSJI) * Contact position is fixed - does not change (i.e. it is a field of Employer) "Comments" is a field of Employer, not Position . "NAICS" stands for "North American Industry Classification System" "Openings" is a field of Position, not Employer "Phone" is a field of Employer * "Position ID" is unique for all employers Hints for HW4 Posted on: Wednesday, January 23, 2019 12:37:55 PM EST Hello ACC 421 Online Students, This email provides some hints for you to complete Homework 4 First, you need to understand what this spreadsheet wants to tell you. Although there are many columns, the main takeaway from this spreadsheet is that "certain employers want certain numbers of certain positions to be filled". Once this is clear, you know you need a "main table" which only consists of three columns: Employer ID, Position ID, and Openings, while all the other columns in the big spreadsheet just serve as additional information for either Employer ID or Position ID. For example, Employer Name explains employer's name by the ID number, Address explains employer's address, NAICS Code explains the industry the employer lies in, and so on. Similarly, Position Title, Wage, Hrs/Wk etc. are additional information for Position_ID. Therefore, you need to have two other tables with these pieces of additional information, like this: Employer Information Table Employer ID, Employer Name, Address, City,... etc. Position Information Table Position _ID, Position Title, Wage, Hrs/Wk, . etc. Now you have three tables: the main table, employer table, and position table. Pay attention, NAICS Code and NAICS_Description are repeated information, i.e. they can explain each other, so they cannot be in the same table for the purpose of 3NF. Therefore, you can leave either one of them in the employer table, and start a new table which only consists of NAICS_ Code and NAICS Description. This table only explains each code with the description. In conclusion, you will have four tables for HW4. If you have further question, please do not h Best regards, Kelvin esitate to e NAIKS_Descript on PositionTitie wage Hrs/W Experience tart Dste End_Dene lopemings NA 2o USA 58152 oie Maroe 42 Toar Cuide ryter round. Employee regnet bstsertin Engen yser roua. Enpkyses reed nat be tuertin Englis. 7 Vinayerd Heve RackpertN4 319 USA 121191 Bei-end-Breekfe: Cre Fersorel Vanege 97254193 2227 e978548319928 236 Resvtist 14.75 10 North Conway NH 306 yeer round. Erployee% reed not be Enger, speekrg Director's st rare 5 pronounced "Buh TRAY tis 5023892737 2115 facp Ckrk 13.0 25 2120 t Shop Clerk 13.50 1332 kin Facies Personrel ianege 8022539*Ftral inted-ervice Resteuraris Vicon Daceo 8036358 2580 1382 sngcs 1382 Skng Feces 6002868233 20 Dy tare 4198374745 202 Cok 191 Bed-and-greailast ins 130 32 11 ect-and-Ereaklasti 024848354 20 HalHaa70 4 Eviel wa CY NL Event S Mail che roll Cler o mbined Payrell Cler dil traive er ith