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, 21.06.2019 23:30

4.11 painting a wall (1) prompt the user to input integers for a wall's height and width. calculate and output the wall's area (integer). note that in this case there is a new line after each prompt. (submit for 1 point). enter wall height (feet): 11 enter wall width (feet): 15 wall area: 165 square feet (2) extend to also calculate and output the amount of paint in gallons needed to paint the wall (floating point). assume a gallon of paint covers 350 square feet. store this value in a variable. output the amount of paint needed using the %f conversion specifier. (submit for 2 points, so 3 points total). enter wall height (feet): 11 enter wall width (feet): 15 wall area: 165 square feet paint needed: 0.471429 gallons (3) extend to also calculate and output the number of 1 gallon cans needed to paint the wall. hint: use a math function to round up to the nearest gallon. (submit for 2 points, so 5 points total). enter wall height (feet): 11 enter wall width (feet): 15 wall area: 165 square feet paint needed: 0.471429 gallons

Answers: 3

Answer

Computers and Technology, 22.06.2019 22:40

When you type the pwd command, you notice that your current location on the linux filesystem is the /usr/local directory. answer the following questions, assuming that your current directory is /usr/local for each question. a. which command could you use to change to the /usr directory using an absolute pathname? b. which command could you use to change to the /usr directory using a relative pathname? c. which command could you use to change to the /usr/local/share/info directory using an absolute pathname? d. which command could you use to change to the /usr/local/share/info directory using a relative pathname? e. which command could you use to change to the /etc directory using an absolute pathname? f. which command could you use to change to the /etc directory using a relative pathname?

Answers: 3

Answer

Computers and Technology, 23.06.2019 22:30

You draw two cards from a standard deck of 52 cards, but before you draw the second card, you put the first one back and reshuffle the deck. (a) are the outcomes on the two cards independent? why?

Answers: 3

Answer

Computers and Technology, 24.06.2019 00:30

Match the sentence fragment in the first column with the appropriate ending in the second column. a little per favore?

Answers: 1

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