Higher Assignment 2023-24

Task 1 - Software Design and Development

Task 1a - Using the problem description, identify the missing functional requirements of the program.

(2 marks)

Task 1b - Using a recognised design technique, design a function called findMaxPos that will return the position of the highest value in an array. This function will be used in steps 2 and 3 of the program.

(4 marks)

Task 1c - Using the problem description and design, implement the program in a language of your choice.

You should:

use a single function to find and return the position of the highest CEO salary, and the position of highest number of employees
use procedures to:
- read data from the ‘companies.csv’ file to parallel arrays
- find and display the difference between the chosen company’s CEO salary and the highest CEO salary
- find and display the highest number of employees employed by a single company, and the number of companies who employ within 10% of that figure.
test your program by using the chosen company Goldman

(15 marks)

Task 1d

(i) Explain why the output from the refinements provided for step 2 would be incorrect if the sample test data was used with Selop as a chosen input.

(1 mark)

(ii) Describe the additional refinements that would be required before step 2.12 to ensure that the correct company name(s) are found.

(2 marks)

Task 1e - Evaluate the efficiency of your own program, with reference to the use of the findMaxPos function.

(1 mark)

Task 2 - Database Design and Development

Task 2a - The database exists with the appropriate entities and all appropriate attributes. Using the user requirements above, create two functional requirements.

(2 marks)

Task 2b(i) - Complete the diagram below showing the cardinality between the Result entity and the two existing entities.

(1 mark)

Task 2b(ii) - State the compound key for the Result entity.

(1 mark)

Task 2c - The NSA would like to know the total number of races won by individual swimmers. Implement the SQL statement to produce the output shown in the table below.

(4 marks)

Task 2d - They want to identify the swimmer who swam in lanes 1 or 8 with the fastest time from any race. Implement the SQL statement(s) to produce the result below.

(4 marks)

Task 2e - The query to test the above SQL statement is provided with the database. When run, the actual output does not match the expected output. Amend the query to produce the expected output.

(2 marks)