The following procedure counts the number of students from Bengaluru whose total marks are less than the average total marks from the “Scores” dataset and stores it in variable A. Let avgT be the average total marks. The programmer may have made mistakes in one or more steps. Identify all such steps (if any). It is a Multiple Select Question (MSQ).Step 1 : Arrange all cards in a single pile called Pile 1Step 2 : Initialize variable A to 0Step 3 : If Pile 1 is empty then stop the iterationStep 4 : Read the top card in Pile 1Step 5 : If X.CityTown == “Bengaluru” and X.Total > avgT then add 1 to AStep 6 : Move the current card to another pile called Pile 2 and repeat from Step 2Step 5

The following procedure took data from the “Scores” dataset and A represents the number of male students whose Physics marks are less than the Mathematics marks but equal to their Chemistry marks. The programmer may have made mistakes in one or more steps. Identify all such steps (if any). It is a Multiple Select Question (MSQ).Step 1 : Arrange all cards in a single pile called Pile 1Step 2 : Initialize variable A to 1Step 3 : If Pile 1 is empty then stop the iterationStep 4 : Read the top card in Pile 1Step 5 : If Gender is ‘M’ and Physics marks = Mathematics marks and Chemistry marks > Physics marks then add 1 to AStep 6 : Move the current card to another pile called Pile 2 and repeat from Step 3

At the end of the execution of the given procedure on the “Scores” dataset, what will A and B represent? (MCQ)Step 1. Arrange all cards in a single pile called Pile 1Step 2. Maintain two variables A, B and initialize A to 101 and B to 0.Step 3. If Pile 1 is empty then stop the iterationStep 4. Read the top card in Pile 1Step 5. If A > Chemistry marks , then store Chemistry marks in AStep 6. If B < Mathematics marks, then store Mathematics marks in BStep 7. Move the current card to another pile called Pile 2 and repeat from Step 3

A retail company manages its sales operations with a database that includes information about salesmen, customers, and orders. Your task is to write a query that counts the number of customers with grades above the average grade in the city of Bangalore.The following table is already created, and the records are inserted into the table.The Sample records are Input format :The input records are already prepopulated, as given in the problem statement.Output format :The result of the query is the count of customers whose grade is above the average grade of customers in Bangalore.AboveAverageGradesCount6Refer to the sample output for the column headers

What will be the value of X after the execution of the following procedure using the “Scores” dataset? (MCQ)(Note: Consider the same sequence as given in the Scores datasets)Step 1: Arrange all cards in a single pile called Pile 1Step 2: Maintain variables A, B, C, D, Y and Initialize them all to 0 except Y. Initialize Y to 100Step 3: Maintain a variable X and initialize it to “None”Step 4: If Pile 1 is empty then stop the iterationStep 5: Read the top card in Pile 1Step 6: If the Town/City is “Chennai” then add one to A. If A < Y then store A in Y and “Chennai” in XStep 7: If the Town/City is “Bengaluru” then add one to B. If B < Y then store B in Y and “Bengaluru” in XStep 8: If the Town/City is “Madurai” then add one to C. If C < Y then store C in Y and “Madurai” in XStep 9: If the Town/City is “Vellore” then add one to D. If D < Y then store D in Y and “Vellore” in XStep 10: Move the current card to another pile called Pile 2 and repeat from Step 4Chennai

You are developing a Student Record Management System in C. The system needs to store and manage information for multiple students, including their names, roll numbers, and marks obtained in different subjects. Implement array in structures to read, write, and compute average marks and the students scoring above and below the average marks for a class of N students. INPUT/OUTPUT EXAMPLE: Enter the number of students: 3 Enter details for 3 students: Student 1: Name: A Roll Number: 1 Marks in 5 subjects: Subject 1: 12 Subject 2: 13 Subject 3: 14 Subject 4: 15 Subject 5: 16 Student 2: Name: BB Roll Number: 2 Marks in 5 subjects: Subject 1: 11 Subject 2: 13 Subject 3: 12 Subject 4: 15 Subject 5: 14 Student 3: Name: CC Roll Number: 10 Marks in 5 subjects: Subject 1: 13 Subject 2: 14 Subject 3: 16 Subject 4: 17 Subject 5: 11 Class average marks: 13.73 Students scoring above average: A (Roll Number: 1) CC (Roll Number: 10) Students scoring below average: BB (Roll Number: 2)