Question: [ PLEASE , I WANT A REAL DBMS EXPERT THAT HAS INSTALLED ORACLE SQL DEVELOPER IN HIS COMPUTER. ] In page 1 of my 5

[PLEASE, I WANT A REAL DBMS EXPERT THAT HAS INSTALLED ORACLE SQL DEVELOPER IN HIS COMPUTER.]
In page 1 of my 5 attachments, there are 2 models of my STUDENTS DATABASE: the physical model and the conceptual model.
[Also important note: In five of my screenshots attached, four of them are related to an example of another person solving the same tasks. PLEASE, BE BASED ON THEM AS AN EXAMPLE, BUT YOU HAVE TO BE BASED ON MY TABLES AS SHOWN IN THE SCREENSHOT OF STUDENTS DATABASE WITH 7 TABLES].
Step1. Open Oracle SQL Developer. If you dont have SAP PowerDesigner to create the model for the database and then generate the SCIRPT, then write the SCRIPT on your own corresponding to the attributes and all 7 tables of my STUDENT physical model. Make sure that 20 DATAS ARE INSERTED IN EACH OF 7 TABLES. So that your script is ready now (PLEASE, I HAVE ATTACHED 4 OTHER SCREENSHOTS IN WHICH I HAVE GIVEN YOU AN EXAMPLE OF THE WHOLE WORK (THAT I AM REQUIRING YOU) OF ANOTHER PERSON, BUT WITH A DIFFERENT TOPIC; PLEASE, BE BASED ON THAT JUST AS AN EXAMPLE FOR YOU TO UNDERSTAND WHAT IS REQUIRED).
Step2. After doing step 1, based on it, write a PL / SQL program, which overwrites database table data using PL/SQL cursor. TAKE SCREENSHOT (LIKE SHOWN IN THE EXAMPLE ATTACHED INDICATED IN YELLOW).
Step3. After doing step 2, Create a database trigger and test its operation. Visualize the test results to show that the trigger is operating and performing the specified functions. TAKE 3 SCREENSHOTS (LIKE SHOWN IN THE EXAMPLE ATTACHED INDICATED IN YELLOW).
Step4. Create function and procedure into SQL WITH statement. Test their operations and show results. TAKE 1 SCREENSHOT (LIKE SHOWN IN THE EXAMPLE ATTACHED INDICATED IN YELLOW).
Step5. Create a PL / SQL program that demonstrates the use of dynamic SQL and dynamic PL / SQL. TAKE 1 SCREENSHOT (LIKE SHOWN IN THE EXAMPLE ATTACHED INDICATED IN YELLOW).
In the end, if you have space, copy and paste all the SCRIPT that you worked with during all the steps.
If it is impossible for you to do that, then do two things: copy the script of just the SQL code of steps 2,3,4,5 and take screenshots after doing SELECT * FROM [tablename] just for the tables (or data) you have used in steps 2,3,4,5(for example, if stud_id attribute appears in any of the screenshots from steps 2,3,4,5, then write SELECT * from Student, so that I can see your data and then I can work modifying the script on my own).
PLEASE, I EXPECT TO GET YOUR ANSWERS IN 3 TO 5 HOURS, BUT THE SOONER, THE BETTER. AND PLEASE, I WANT YOU TO READ MY ALL THIS CHEGG TEXT AND THE SCREENSHOTS CAREFULLY.
 [PLEASE, I WANT A REAL DBMS EXPERT THAT HAS INSTALLED ORACLE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!