Computers and Technology, 21.05.2021 09:50 kereshmeh

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.

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

memor

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 01:00

What is added to the < meta > tag to describe the encoding type?

Answers: 1

Answer

Computers and Technology, 22.06.2019 06:00

The width of a piece of rectangular land is 5m shorter rhan 1/3 of its length .find the width of the land if the length is 60m,150m.

Answers: 1

Answer

Computers and Technology, 22.06.2019 15:30

In a compound condition, both conditions on either side of the logical operator and must be true for the overall condition to be true. a: true b: false

Answers: 1

Answer

Computers and Technology, 23.06.2019 02:00

Consider the following function main: int main() { int alpha[20]; int beta[20]; int matrix[10][4]; . . } a. write the definition of the function inputarray that prompts the user to input 20 numbers and stores the numbers into alpha. b. write the definition of the function doublearray that initializes the elements of beta to two times the corresponding elements in alpha. make sure that you prevent the function from modifying the elements of alpha. c. write the definition of the function copyalphabeta that stores alpha into the first five rows of matrix and beta into the last five rows of matrix. make sure that you prevent the function from modifying the elements of alpha and beta. d. write the definition of the function printarray that prints any onedimensional array of type int. print 15 elements per line. e. write a c11 program that tests the function main and the functions discussed in parts a through d. (add additional functions, such as printing a two-dimensional array, as needed.)

Answers: 3

Answer

You know the right answer?

The three tables below make up the database of a university. In the student table they come memoriz...

Questions