Neco 2025 Computer Studies Question 4

A secondary school maintains a student information system that records the following fields for each pupil: StudentID (a six‑digit numeric identifier), Name, Date of Birth, Gender, Class, and the scores obtained in Mathematics, English and Science (each out of 100). The school wishes to store this data in a relational database and generate two types of reports: 1. The average total score (sum of the three subjects) for each class. 2. A list of students who have scored above 85 in any one of the three subjects. Answer the following: (a) Identify an appropriate primary key for the table and suggest suitable data types for each field. (b) Write an SQL query that computes the average total score per class. (c) Write an SQL query that lists the StudentID and Name of students who scored above 85 in at least one subject. (d) Explain two advantages of using a relational database over a flat‑file (e.g., spreadsheet) for this application.