SUBJECT:DATABASE MANAGEMENT AND ADMINISTRATION

QUESTION:

TASK 7.1

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 2^nd 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.
   • UPDATE STUDENT SET ECITY = ISB WHERE EID>101
   • 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.