Consider the following schema:
ExtraCurriculum (Course_code, school, title, description) Enrolls_in (Course_code, StudentID)
Student (StudentID, DOB, name, address, phone_no)
a) Use Relational Algebra to find students who are either enrolled in ‘pottery classes’ or ‘self-defence classes’ using UNION.
b) Use Relational Algebra to find students who are not enrolled in any extra curriculum courses.
c) Use SQL to list the students in alphabetical order who are enrolled in more than 3 different kinds of extra curriculum courses.
5 freelanceria on tarjonnut keskimäärin $29 tähän työhön
Hi I am C#.net and Database Developer and I worked on many projects. I will provide you 100% satisfaction work and full service. I will do your project with in your given budget and time frame. Thanks