Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Chapter 4 Assignment You have been hired to review the accuracy of the books of Northeast Seasonal Jobs International (NSJI) a job broker. NSJI matches
Chapter 4 Assignment You have been hired to review the accuracy of the books of Northeast Seasonal Jobs International (NSJI) a job broker. NSJI 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 atached. 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) You have ascertained from an interview with your client (NSJI ifedd hnge Giod Eple . "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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started