Schools(Name,Address,Faculties,Type,Country,Students_number,Teacher_Number,Ranking)
Write down the relational algebra for the following queries,
i)What will be the name of the school which has faculty members not less than 45 with a ranking
over 2.5.
ii)Jane lives in Cardiff & she is finding a school near her house for the convenient journey to the
school. Help her to find out the name and ranking of the schools near her house.
iii)According to the ministry of education of California they have imposed a ratio of teacher &
students number like 1:40(teacher : student).Now help her to find out schools.
Answers
Answered by
0
Answer:
ok please mark as brainliest please
Similar questions