Hello, Im need to programming and need son assistance with the following assignment:
"Mr. Chroné has decided to award each house a percentage of the $140,000 sponsorship fund
obtained to go towards next year’s athlete training.
Using the results from the House Total query:
1. Write a structured algorithm or flowchart to:
a) Accept the names and point scored for each house
b) Calculate the total points amassed in the Sprint events. c) Find the house with the highest and lowest points.
d) Calculate the percentage allocated from the sports fund based on the conditions:
45 % of the funds to the house with the highest points and 17% to the house with the least points.
e) Output :
i. the total points scored
ii. the names and points of the two houses and the respective amounts earned.
2. Represent the algorithm or flowchart using pseudo-code.
3. Create a trace table for the algorithm or flowchart.
4. Translate the algorithm or flowchart to Pascal Code.
5. Compile and run the program.
Print the algorithm or flowchart, trace table, test data, Pascal program and the output