Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Question What integration level should an employer choose?

Answered: 1 week ago