Question: 1. Queries in Relational Algebra and SQL Consider a database for the basic and secondary education system (B + S) with the following attributes: -

 1. Queries in Relational Algebra and SQL Consider a database for

1. Queries in Relational Algebra and SQL Consider a database for the basic and secondary education system (B + S) with the following attributes: - Curricular_Year = {1, 2, 3,... 12} - Teaching_grade = {basic, secondary} - Nature = {public education, private education} - Type = {regular basic education, basic vocational education, secondary education, secondary vocational education, other basic} - Area = {London, Manchester, Newcastle, Southampton, Leeds} -Transitions = {approved, retained, abandoned, rejoined} And with the following tables: - students (student.ID ->name, address, contact, education_supervisor) - history (id.Fact-> student.ID, school_year , curricular_year, area, id.Type, nature, transition) -types (id.Types ->id.Level) -level (id.Level) Express the query in SQL avoiding the WITH clauses, TOP and LIMIT: 1.1 In the academic year 2014-2015 and in the year 2015-2016, which students (id. Student) who dropped out of education in the 12th grade in the Area of London and Manchester ? Use the UNION operator in the query

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!