Question

use 3NF on case provided in the image

You will draw a normalized ehtity relationship diagram (ERD) for the case described below. You only need to show your final ERD in 3NF Case The North Carolina Division of Employment Security wants to build a system that tracks job seeking activity for unemployed individuals. When each individual applies for unemployment (referred to as an applicant) he/she is assigned a job coach who is responsible for monitoring the applicant's job seeking activity. The development team has tentatively identified the following attributes for each applicant: APPLICATION (This is the initial entity name. You must properly identify all other entities.) Applicant ID Applicant Last Name Applicant First Name Applicant Birthdate Applicant Age Job Coach Name Job Coach Phone Positions Applied For (repeat 1-n times) Position Code Position Description Date Position became available Number of days position open

Answer 1

STATUS-JOR APPLICANT APPLICANT APP- LASTNAMA SELE CtION-ST Co DE Arp-Age Tol CoACH K$or.co4咻Naus /lf'asITION-2-Es し OPEN