Answered step by step
Verified Expert Solution
Question
1 Approved Answer
consider the following relations ( attributes in brackets and primary keys underlined ) activity ( act id , actname,actlocation ) actid:activity ID actname: description of
consider the following relationsattributes in brackets and primary keys underlined activityact idactname,actlocation actid:activity ID actname: description of activity eg 'circuits','maratan','swimming for beginners' actLocation: where the activity takes place, eg 'main pool'
member memID memName, DoB,memEmail,memCat memID : member ID characters, eg mem name: member's name DOB :member's date of birth memEmail: member's email address memcat: category of membership, eg 'junior','adult','senior' BookingmemIDsesID memID:member ID sesID:Session IDSession sesID actID, sesDate sesID : Session ID characters, eg actID : Activity ID sesDate : Date of session Price actID memCat, sesPrice actID : activity ID memCat: category of membership sesPrice : price per session in pence Choose the one correct SQL statement to perform each of the following queries operations
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started