Question
Microsoft Access is a frequently used piece of enterprise software that manages these systems. For 10 points each:
[10e] Name these systems, whose “relational” type should obey ACID (“acid”) properties and store large amounts of organized information in rows and columns.
ANSWER: databases
[10m] The JOIN, SELECT, and WHERE keywords are used to query relational databases with this language. Programmers argue over whether or not this language’s name should be pronounced as a three-letter initialism.
ANSWER: SQL (“S-Q-L” or “sequel”) [or Structured Query Language]
[10h] This property is the first of the four ACID properties, and states that a database transaction must either completely finish or not occur. More generally, this property describes operations that cannot be interrupted.
ANSWER: atomicity
<Other Science>
Summary
2024 ACF Fall at Cornell | fall | Y | 9 | 17.78 | 78% | 78% | 22% |
2024 ACF Fall at Ohio State | fall | Y | 8 | 16.25 | 88% | 63% | 13% |
2024 ACF Fall at Washington | fall | Y | 6 | 18.33 | 83% | 83% | 17% |
2024 ACF Fall at Georgia | fall | Y | 12 | 18.33 | 83% | 92% | 8% |
2024 ACF Fall at North Carolina | fall | Y | 9 | 11.11 | 33% | 67% | 11% |
2024 ACF Fall at Claremont Colleges | fall | Y | 5 | 24.00 | 100% | 100% | 40% |
2024 ACF Fall at Rutgers | fall | Y | 9 | 15.56 | 44% | 67% | 44% |
2024 ACF Fall at Illinois | fall | Y | 9 | 16.67 | 56% | 100% | 11% |
Data
Purdue B | Chicago B | 10 | 10 | 0 | 20 |
Illinois A | Northwestern A | 0 | 10 | 0 | 10 |
Illinois B | Indiana | 10 | 10 | 0 | 20 |
Illinois D | Illinois C | 10 | 10 | 0 | 20 |
Iowa A | Chicago A | 0 | 10 | 0 | 10 |
WashU B | Iowa B | 0 | 10 | 0 | 10 |
Notre Dame A | Notre Dame C | 0 | 10 | 0 | 10 |
Purdue A | Notre Dame B | 10 | 10 | 10 | 30 |
Purdue C | WashU A | 10 | 10 | 0 | 20 |