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
| Columbia A (UG) | Columbia J (DII) | 0 | 10 | 0 | 10 |
| Maryland A (DII) | Fordham A | 10 | 10 | 0 | 20 |
| Lehigh A (UG) | Rutgers B | 10 | 0 | 10 | 20 |
| Lehigh A (UG) | Rutgers B | 10 | 0 | 10 | 20 |
| Lehigh A (UG) | Lehigh B (DII) | 0 | 0 | 10 | 10 |
| Lehigh A (UG) | Lehigh B (DII) | 0 | 0 | 10 | 10 |
| Lehigh A (UG) | Rutgers B | 10 | 10 | 10 | 30 |
| Lehigh A (UG) | Rutgers B | 10 | 10 | 10 | 30 |
| Lehigh A (UG) | Lehigh B (DII) | 0 | 10 | 10 | 20 |
| Lehigh A (UG) | Lehigh B (DII) | 0 | 10 | 10 | 20 |
| Bard A (UG) | Maryland B (DII) | 0 | 0 | 0 | 0 |
| Columbia B | NYU A (UG) | 10 | 10 | 10 | 30 |
| Rowan A (DII) | NYU B | 0 | 0 | 0 | 0 |
| Penn B (DII) | Penn A (DII) | 10 | 10 | 10 | 30 |
| Lehigh B (DII) | Princeton A (UG) | 0 | 10 | 0 | 10 |