Neco 2020 Data Processing Question 49
Practice objective / multiple choice question 49 from the 2020 Neco Data Processing examination.
Relation Students(SID, Name, DeptID) contains 120 tuples. Relation Departments(DeptID, DeptName, HOD) contains 8 tuples. DeptID in Students references Departments.\n(a) Write a relational algebra expression that lists the names of students together with their department names, but only for those departments that have more than 10 students.\n(b) Assuming the 120 students are distributed equally among the 8 departments, how many tuples will the expression in part (a) produce?
Answer Options
About This Question
This is Neco 2020 Data Processing Question 49. It is one of the objective questions from the 2020 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.