Neco 2025 Data Processing Question 39
Practice objective / multiple choice question 39 from the 2025 Neco Data Processing examination.
Consider two relations. STUDENTS(SID, Name, Dept) contains 120 tuples and DEPARTMENTS(DID, DeptName, Head) contains 8 tuples. The attribute STUDENTS.Dept references DEPARTMENTS.DID. (a) Write a relational algebra expression that returns the names of students who belong to departments whose head's name starts with the letter ‘A'. (b) Assuming each department has the same number of students and exactly 2 of the 8 department heads have names beginning with ‘A', how many student names will the expression return?
Answer Options
About This Question
This is Neco 2025 Data Processing Question 39. It is one of the objective questions from the 2025 Neco Data Processing examination.
Difficulty level: Medium .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.