Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a SQL trigger that calculates the total marks of the student while inserting the record. After that, Insert any record with total marks less

Write a SQL trigger that calculates the total marks of the student while inserting the record. After that, Insert any record with total marks less than 50 and show the name and total marks of the student who have scored total greater than 50. SQL Table with the following schema -
Tables Schema as Below:
Students
columnName dataType
id INTEGER
name VARCHAR(20)
subj1 INTEGER
subj2 INTEGER
subj3 INTEGER
total INTEGER

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

Semantics In Databases Second International Workshop Dagstuhl Castle Germany January 2001 Revised Papers Lncs 2582

Authors: Leopoldo Bertossi ,Gyula O.H. Katona ,Klaus-Dieter Schewe ,Bernhard Thalheim

2003rd Edition

3540009574, 978-3540009573

More Books

Students also viewed these Databases questions