Neco 2025 Computer Studies Question 5

A secondary school intends to develop a computerised system for storing and managing student academic records. The system must satisfy the following requirements: - Each student is identified by a unique admission number and has a name and date of birth. - The school offers several courses; each course has a unique course code, a title and a number of credit units. - A student may enrol in any number of courses. For every enrolment the student obtains a score (0‑100) for that course. - The school wishes to generate a transcript that lists the courses taken, the scores obtained and the Grade Point Average (GPA). The GPA is calculated as: GPA = \( \frac{\sum (\text{grade point}\times\text{credit units})}{\sum \text{credit units}} \) where the grade points are assigned as follows: 70‑100 = 5, 60‑69 = 4, 50‑59 = 3, 45‑49 = 2, 40‑44 = 1, below 40 = 0. Answer the following: (a) Sketch an Entity‑Relationship (ER) diagram for the system. Identify the entities, their key attributes and the relationships between them. (b) Write the SQL CREATE TABLE statements for the tables derived from your ER diagram, including appropriate primary‑key and foreign‑key constraints. (c) Using the data below, calculate the student’s GPA (round to two decimal places). • Course CS101 – 3 credit units – Score 78 • Course MTH102 – 2 credit units – Score 65 • Course ENG103 – 2 credit units – Score 55 (d) State two advantages of implementing the system as a relational database rather than as a flat‑file (e.g., a spreadsheet).