Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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)
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)
- Display 2nd row of Student table using Cursors.
- Display all records of Enrollment table which are placed at even rows.
- 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.
- Write a mechanism which must not allow user to delete more than 1 records using cursor and transaction.
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