Computers and Technology, 21.05.2021 09:40 princessbrebre4482

Triggers, please help The three tables below make up the database of a university. In the student table they come
memorized the students for each of which is specified the matriculation, name, surname, the course of
degree to which he is enrolled (computer science, mathematics, physics, engineering, etc.) and the average of his marks of exams taken. The courses offered by each class are stored in the course table, while in the table “exam passed” all the exams taken by the students are recorded. Write two triggers:
1. the first to verify the correct taking of an exam and in particular to check that:
to. the exam was taken by a student with a freshman record registered in the student table,
b. the student is enrolled in the degree program corresponding to the degree program indicated in the course table,
c. the grade is a number between 18 and 30,
d. honors are given only in the case of a grade of 30. (like an A plus)
2. the second must update the student average after each insertion, modification (grade) or
elimination of an exam taken.

Triggers, please help

The three tables below make up the database of a university. In the student

Answers: 1

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 23.06.2019 07:10, anika420

If you want to import a picture into a dtp application, what must you do first? draw an image frame. import text. open the folder containing the file. select get image… from the windows menu.

Answers: 2

continue

Computers and Technology, 23.06.2019 11:00, swelch2010

Describe three characteristics of at-risk drivers. a. b. c. describe three characteristics of safe drivers. a. b. c. describe three driver errors that could cause a collision. a. b. c. how will this information affect you as a driver now and in the future? (2-3 sentences)

Answers: 2

continue

Computers and Technology, 24.06.2019 08:00, nataliamontirl4230

Java the manager of a football stadium wants you to write a program that calculates the total ticket sales after each game

Answers: 1

continue

Computers and Technology, 24.06.2019 09:50, trenrain

Create a string list. 2. use console. readline() to collect values of firstname, lastname, street, city, state, zip, save them to list. 3. write a simple linq statement, call method uppercasewords() to change first letter to uppercase. 4. create a foreach statment to display the information. public static string uppercasewords(string value) { char[] array = value. tochararray(); if (array. length > = 1) { if (char. islower(array[0])) { array[0] = char. toupper(array[0]); } } for (int i = 1; i < array. length; i++) { if (array[i - 1] == ' ') { if (char. islower(array[i])) { array[i] = char. toupper(array[i]); } } } return new string(array);

Answers: 3

continue

You know the right answer?

Triggers, please help The three tables below make up the database of a university. In the student t...