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

Another question on Computers and Technology

Computers and Technology, 22.06.2019 12:30

An atom's diameter is about 0.1 nanometer (1×10-9m), and a human hair is about 1×10-3m. how many times greater is a human hair than an atom's diameter? sorry pushed wronf button but this is math

Answers: 3

Answer

Computers and Technology, 22.06.2019 17:20

[a] create a class called “cycle” which has two instance integer variables as properties, “numberofwheels” and “weight.” create a constructor with two parameters, using the same variable names in the parameter list. assign each variable to numberofwheels” and “weight” respectively. write a separate application to test the class and display its properties. note: do not change the names of the instance variables or the variables listed in the constructor’s parameter list. [b] edit your class cycle by adding a default constructor which will assign the default values of 100 to represent the numberofwheels, and 1000 to represent the weight, by invoking a call to the other constructor. modify your application created in [a] to test the class.

Answers: 3

Answer

Computers and Technology, 23.06.2019 18:20

What is wi-fi infrastructure? a metropolitan area network that uses radio signals to transmit and receive data a communications technology aimed at providing high-speed wireless data over metropolitan area networks a means by which portable devices can connect wirelessly to a local area network, using access points that send and receive data via radio waves includes the inner workings of a wi-fi service or utility, including the signal transmitters, towers, or poles and additional equipment required to send out a wi-fi signal

Answers: 2

Answer

Computers and Technology, 24.06.2019 00:40

To maintain clarity and focus lighting might be needed

Answers: 2

Answer

You know the right answer?

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

Questions