Answered You can hire a professional tutor to get the answer.
A fitness centre maintains a database of information about the various classes that are available for members of the centre to take.
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 (MemberID, 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 all classes suitable for 'Over 60s'.
c. List the names of instructors who run sessions in the classes 'Aqua Flex', 'Aqua Deep', or both.
d. List the names of all members who participated in a class held in Studio 5 on 28/8/2018, and the name of the class they participated in.
e. List the names of members who participated in any class with a venue capacity greater than 20.
f. List the details of all sessions running on 28/8/2018, and the names of the members who have signed up for each of them (if any).
g. List the names of any instructors who run sessions in both Studio 2 and the Warm Water Pool.
h. List the names of members who have either participated in classes for the Over 60s, classes held in the Warm Water Pool, or both.
i. List the names of the members who have NOT participated in a 'Yoga' class.
j. List the names of members who have participated in all of the different classes offered.
