Question: 1 create a query shows the booking id, booking date,event name,event rate, the artist name and artist email Question 2 create a sql query that
1 create a query shows the booking id, booking date,event name,event rate, the artist name and artist email Question 2 create a sql query that will display the artist who has the least number of performances. Question 3 CREATE A SQL QUERY THAT WOLL DISPLAY THE ARTISTS NAME Question 4 CREATE A PL/SQL QUERY TO DISPLAY ARTISTS NAME AND THE BOOKING DATE FOR EVENT ID 1001 QUESTION 5 management of the events has decided to allow 10% discount on all events that cost cover r250. Create a pl/sql query to display the event name and price, with or without applied discount question 6 create a view called Event_Schedules that will display event names which will held between 1 July 2024 and 28 august 2024 Question 7 Create a stored procedure for this database that is able to pull out the bookings details of max trillion using the artists name as an input parameter and show the code to execute the procedure. Question 8. Create a function that is meaningful and relevant to this database. Your function should accept least one input parameter and display the relevant information. In your solution display the data for any customer and provide the code to execute the function with relevant exception handling. Question 9 You are tasked with securing the database you've implemented. describe the tools platforms you would use making reference to the case study. Question 10. Using examples, discuss the various pl/sql scalar data types available to store specific kinds of d
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
