Assume the following tables: Student (studid, email, name) Club (clubid, telephone, name, #president) MemberOf(#clubid, #studid ) Activities(actid, actdt, place) Organize (#actid , #clubid , fee), Then answer the following questions by using SQL. 1- Create a stored procedure called 'StudentsActivities' to display the list of students and the activities in which they participated. 2- Create a stored Function called 'Checkavailability' to check whether 'Salalah Hall' is busy or not in a given date.
Assume the following tables:
Student (studid, email, name)
Club (clubid, telephone, name, #president)
MemberOf(#clubid, #studid )
Activities(actid, actdt, place)
Organize (#actid , #clubid , fee),
Then answer the following questions by using SQL.
1- Create a stored procedure called 'StudentsActivities' to display the list of students and the activities in which they participated.
2- Create a stored Function called 'Checkavailability' to check whether 'Salalah Hall' is busy or not in a given date.
3- Create a stored Procedure called 'CheckavailabilityProc' to call the function 'Checkavailability' and display the appropriate message according to the value returned by the function (If function returns true, the procedure will display 'Salalah Hall is free on date ######' otherwise'Salalah Hall is busy on date ###### ').
Step by step
Solved in 3 steps
