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.
Answers: 2
Computers and Technology, 23.06.2019 02:30
What is the power dissipated by a resistor with a current of 0.02 a and a resistance of 1,000 ? a. 200 w b. 20 w c. 0.4 w d. 4 w
Answers: 1
Computers and Technology, 23.06.2019 16:30
If i wanted to include a built-in calendar in a document, what option could i select? draw table insert table insert chart quick tables
Answers: 1
Computers and Technology, 23.06.2019 18:00
Which is a possible benefit of having a good credit history? having a checking account low interest rate on a car loan high interest rate on a credit card offer bankruptcy
Answers: 1
Computers and Technology, 24.06.2019 03:30
The footer area of a web page generally houses which website feature? terms of use web page content business name or title menu headings
Answers: 1
The three tables below make up the database of a university. In the student table they come
memoriz...
Mathematics, 08.02.2021 16:40
Mathematics, 08.02.2021 16:40
Mathematics, 08.02.2021 16:40
History, 08.02.2021 16:40
Mathematics, 08.02.2021 16:40
Biology, 08.02.2021 16:40
Biology, 08.02.2021 16:40
Mathematics, 08.02.2021 16:40
Chemistry, 08.02.2021 16:40
Mathematics, 08.02.2021 16:40
Mathematics, 08.02.2021 16:40
Mathematics, 08.02.2021 16:40