dear experts need answers asap voteup

Poreglopu a) b) Styles Explain the three basic stages of normalisation, Consider the following narrative and associated table (Table 1) in un-normalised form (UNF) for an engineering firm's daily operations sheet: An operations sheet details all customer jobs for the day. A job is for one customer and consists of a sequence of processes where each process performs many operations on one machine. An operation will use a specific tool. Each job has a specific start and end date, and each operation is timed. The operations sheet has the following data items in UNF: UNF Table Name Job No Customer No Customer Name Customer Address Job Start Date Job Finish Date Job Status Process Sequence No OPERATIONS Sequence Start Date Time Sequence End Date Time Machine Operation No Operation Deve Operation Time Tool Tool Dese Table 1: Un normalized Operation Table You are required to take the above UNF data to third normal form (3NF), to obtain the relevant entities and attributes. Show the steps from UNF O INF 2NF N naming any new tables formed. For each new or modified table, you must provide prefix primary key elements with an asterisk (*) and prefix foreign key clements with a hash (#). Write your answers in ONE (1) page only. Poreglopu a) b) Styles Explain the three basic stages of normalisation, Consider the following narrative and associated table (Table 1) in un-normalised form (UNF) for an engineering firm's daily operations sheet: An operations sheet details all customer jobs for the day. A job is for one customer and consists of a sequence of processes where each process performs many operations on one machine. An operation will use a specific tool. Each job has a specific start and end date, and each operation is timed. The operations sheet has the following data items in UNF: UNF Table Name Job No Customer No Customer Name Customer Address Job Start Date Job Finish Date Job Status Process Sequence No OPERATIONS Sequence Start Date Time Sequence End Date Time Machine Operation No Operation Deve Operation Time Tool Tool Dese Table 1: Un normalized Operation Table You are required to take the above UNF data to third normal form (3NF), to obtain the relevant entities and attributes. Show the steps from UNF O INF 2NF N naming any new tables formed. For each new or modified table, you must provide prefix primary key elements with an asterisk (*) and prefix foreign key clements with a hash (#). Write your answers in ONE (1) page only