Consider the following schema and write SQL query for given statements. Student ( regNo, sName, sCity, sCGPA, sAge) Course ( cCode, cName, credit_hours) Enrollment (regNo, cCode,...


Consider the following schema and write SQL query for given statements.


Student ( regNo, sName, sCity, sCGPA, sAge)
Course ( cCode, cName, credit_hours)
Enrollment (regNo, cCode, semester,quality_points,Grade)



1- Display 2nd row of Student table using Cursors.



2- Display all records of Enrollment table which are placed at even rows.



3- Execute given query in SQL and do as directed.
a) UPDATE STUDENT SET ECITY = ‘ISB’ WHERE EID>101
b) Count how many records have been updated in above query using cursor.



4- Write a mechanism which must not allow user to delete more than 1 records using cursor and transaction.



Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here