Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
