please i need help with this project, its due tomorrow

A) Case Study: Imagine that a lecturer of an XYZ College conducted activities for different students and trying to manage the activities system for better performance. This is to enable him to manage the student activities, join date and hour's student has taken for each activities. Also help the lecturer keep track of students' performance during each activity. In fact, he hired a developer to design and build Students, Activity and Activity type tables to record all the activities performed by each student. Unfortunately, that developer could not complete the work. Thus, the lecturer is seeking a group of creative developers who are capable of building a relational database based on the given data. The given tables consist of the following data: 1. Students: to store the data of the student as shown below. 2. Activity: to store the activity of student with the date of joining. (Note: Std id and Act id each one alone is toreign key) 3. Activity_type: to store the data regarding students' activities and the price of it. B) Tasks Based on the given information above, do the following tasks: Step 1: Create tables and manipulate their data 3 Marks Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: A) Create ALL the tables according to the given specifications above. B) Use the INSERT commands to add records exactly as mentioned in the table. C) The Instructor is no longer wants to keep 'writing' activity in the activity_type table, so he wants to remove [LAB3](1) it. [LAB-3] Step 2: Data Retrievals 5 Marks Use SQL Developer or Oracle Live SQL to write the appropriate SQL commands as follows: A) Retrieve the id and name of students who live in a city that begin with A B) Retrieve the students' id and name of those who are not registered in any activity. [LAB-4B-6] C) Retrieve the id, name and activity id of students who work more than 5 hours at an activity. [LAB-6] (1) D) Demonstrate the aggregation function on activity table showing maximum, minimum, average and sum of price. E) Update the price of activity whose price is 100 by 20%. [LAB-5] (1) Step 3: Build PL/SQL Named Blocks [LAB-4] (1) Use SQL Developer or to write the appropriate SQL commands as follows: A) FUNCTION: Use the students table to create a function called 'Return_name' which accepts an input parameter 'std__id', and print the name of the student with that id. Then execute this function with std_id = 324. [LAB-7] B) PROCEDURE: Use the activity_type table to create a procedure called 'Get_Activity_Name' that takes the activity id as an input parameter to show its corresponding activity name. Then execute this procedure with act_id =4. [LAB-7] (1)