Please help me from Question F to J Question 1: Relational algebra (20 marks) A fitness centre maintains a database of information about the various classes that are available for members of the centre to take. Each class (Zumba, Pilates, Aqua Fit, etc) may offer several sessions per week. Each session is led by a qualified instructor at a particular day and time, and is held in one of the centre’s venues. Each session has a limited number of places available and members must sign up for a session. Basic Information about members, instructors, classes and venues are also held in the database. The schema for this database is as follows: (note that primary keys are shown underlined, foreign keys in bold) MEMBER (MemberlD, MemberName, MemberEmail) CLASS (ClassName, Description, SuitableFor) INSTRUCTOR InstructorName, InstructorEmail, Specialty) VENUE (VenueName, Capacity SESSION (SessionID, DayAndTime, NumberOfPlaces, ClassName, VenueName, InstructorName) PARTICIPANT (SessionID, MemberID) Provide relational algebra (NOT SQL) queries to find the following information. Each question is worth 2 marks. NOTE: You can use the symbols ơ, П, *, etc or the words ‘RESTRICT’, PROJECT, etc as you prefer Use nested brackets or intermediate relations, as you prefer You do not need to try to make efficient queries-just correct ones. * Where you use a join, always show the join condition. a. List the name and specialty of all instructors. b. List the class name and description of allclasses suitable for ‘Over 60s C. List the names of instructors who run sessions in the classes ‘Aqua Deep, ‘Aqua Fit’, or both. d. List the names of all members who participated in a class held in Studio 5 on 19/9/2018, and the name of the class they participated in. List the names of members who participated in any class with a venue capacity greater than 30. List the details of all sessions running on 19/9/2018, and the names of the members who have signed up for each of them (if any). List the names of any instructors who run sessions in both Studio 1 and Studio 2. List the names of members who have either participated in classes for the Over 60s, classes held in the Warm Water Pool, or both e. f. g. h. i. List the names of the members who have NOT participated in a Zumba class. j. List the names of members who have participated in all of the different classes offered.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more