Computer Science (AS & A Level) · Oct / Nov 2021 · Paper 22 · Question 5

A company has several departments. Each department stores the name, email address and the status of each employee in that department in its own text file. All text files have the same format. Employee details are stored as three separate data strings on three consecutive lines of the file. An example of the first six lines of one of the files is as follows: File line Comment 1 First employee name 2 First email address 3 First employee status 4 Second employee name 5 Second email address 6 Second employee status A procedure MakeNewFile() will: • take three parameters as strings: ○ an existing file name ○ a new file name ○ a search status value • create a new text file using the new file name • write all employee details to the new file where the employee status is not equal to the search status value • count the number of sets of employee details that were in the original file • count the number of sets of employee details that were written to the new file • produce a summary output. An example summary output is as follows: File Marketing contained 54 employee details 52 employee sets of details were written to file NewMarketingList

Read automatically from the paper; the printed page above is exact.