Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Auditing

Authors: Michael C. Knapp

11th edition

1305970810, 9781337514811, 1337514810, 978-1305970816

More Books

Students also viewed these Accounting questions

Question

What does stickiest refer to in regard to social media

Answered: 1 week ago