Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[ 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 of my attachments, there are 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 TABLES
Step 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 tables of my STUDENT physical model. Make sure that DATAS ARE INSERTED IN EACH OF TABLES. So that your script is ready now PLEASE I HAVE ATTACHED 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
Step After doing step based on it write a PL SQL program, which overwrites database table data using PLSQL cursor. TAKE SCREENSHOT LIKE SHOWN IN THE EXAMPLE ATTACHED INDICATED IN YELLOW
Step After doing step 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 SCREENSHOTS LIKE SHOWN IN THE EXAMPLE ATTACHED INDICATED IN YELLOW
Step Create function and procedure into SQL WITH statement. Test their operations and show results. TAKE SCREENSHOT LIKE SHOWN IN THE EXAMPLE ATTACHED INDICATED IN YELLOW
Step Create a PL SQL program that demonstrates the use of dynamic SQL and dynamic PL SQL TAKE 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 and take screenshots after doing SELECT FROM tablename just for the tables or data you have used in steps for example, if studid attribute appears in any of the screenshots from steps 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 TO HOURS, BUT THE SOONER, THE BETTER. AND PLEASE, I WANT YOU TO READ MY ALL THIS CHEGG TEXT AND THE SCREENSHOTS CAREFULLY.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started