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 03:40

Mary's manager told her she should insert a graphic into her documentwrite mary a brief note describing how to insert a graphicin a word processing document.

Answers: 1

Answer

Computers and Technology, 23.06.2019 03:10

Acomputer has a two-level cache. suppose that 60% of the memory references hit on the first level cache, 35% hit on the second level, and 5% miss. the access times are 5 nsec, 15 nsec, and 60 nsec, respectively, where the times for the level 2 cache and memory start counting at the moment it is known that they are needed (e.g., a level 2 cache access does not even start until the level 1 cache miss occurs). what is the average access time?

Answers: 1

Answer

Computers and Technology, 23.06.2019 09:30

Given a link with a maximum transmission rate of 32.8 mbps. only two computers, x and y, wish to transmit starting at time t = 0 seconds. computer x sends filex (4 mib) and computer y sends filey (244 kib), both starting at time t = 0. statistical multiplexing is used, with details as follows packet payload size = 1000 bytes packet header size = 24 bytes (overhead) ignore processing and queueing delays assume partial packets (packets consisting of less than 1000 bytes of data) are padded so that they are the same size as full packets. assume continuous alternating-packet transmission. computer x gets the transmission medium first. at what time (t = ? ) would filey finish transmitting? give answer in milliseconds, without units, and round to one decimal places (e.g. for an answer of 0.013777 seconds you would enter "13.8" without the quotes)

Answers: 3

Answer

Computers and Technology, 24.06.2019 01:10

Create a program that will take in a single x and y coordinate as the origin. after the input is provided, the output should be all of the coordinates (all 26 coordinates read from the “coordinates.json” file), in order of closest-to-farthest from the origin.

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