Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part2- Instructions: Serial Transactions [5 Marks] Among databases, only Central db was modified. The Central Database was given a new table: Central_Course_Size. This table satisfies
Part2- Instructions: Serial Transactions [5 Marks] Among databases, only Central db was modified. The Central Database was given a new table: Central_Course_Size. This table satisfies a further requirement about course sizes, and is given the attribute CourseNo, which is its primary key, and CapSize, which lists the size limit of the course. Write a program in the PL/Sql environment to complete the code below: SET serveroutput on; DECLARE 1 " Student changing classes " movingstudent int; I Classes size information */ caplimit int currentSize int; BEGIN I" Select student that wants to change departments such as John*/ r* Finds the class size and class limit of some engineering course such as 203% If (currentSize >= caplimit) THEN " do not let the student change departments if course has enough capacity"I ELSE "drop the student's science courses if leaving the department"/ move the student from the science database to the engineering database *l I" add the student into some engineering courses */ END IF; dbms_output.put_line('Finished'); END
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