Answered step by step
Verified Expert Solution
Link Copied!

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 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

4th Edition

0805360476, 978-0805360479

More Books

Students also viewed these Databases questions