DB Challenge 2014
Team Based Database Query Challenge for Real Business Problems
I. OBJECTIVES
-
Encourage students to improve critical thinking;
-
Expose students to real world applications of database queries;
-
Provide students with an opportunity to work in a team towards a common goal; and
-
Identify and recognize students who exhibit exemplary performance in db design and query competition.
II. THE COMPETITION
- The DB Challenge is a competition participated in by teams of three (3) students with technical knowledge of database design and queries.
- There will be six (6) database problems that the students have to solve.
- The team who gets the most number of problems solved wins.
- In the event that at least two teams solved the same number of problems, the team who gets the fastest finish time wins.
- Every team will have the following scoreboard:
Problem | Time Finished | Penalty | Adjusted Time Finished | |
A | 13:30 | 13:30 | 0:30 | |
B | ||||
C | 14:20 | 0:20 | 14:40 | 1:40 |
D | ||||
E | 15:00 | 15:00 | 2:00 | |
F | 0:20 | |||
TOTAL | 4:10 |
The scoreboard indicates that the team only solved Problems A, C, and E, with the final time the problems were submitted and acknowledged correct: 13:30, 14:20, and 15:00 respectively. However, Problem C incurred a 20 minute penalty, having the adjusted time finished for Problem C: 14:40. Adding up the total duration (with 13:00 as reference), this team has:
SOLVED 3 Problems, with total time of 4:10.
Note: Score will be based on number of problems solved, then total time elapsed for solved problems.
III. SUBJECT COVERAGE
- Information and Communications Technology – topics include data organization, database applications, logic design and switching, data structures, & algorithms.
- Business and Finance – topics include sales, pricing, accounting, finance.
- Mathematics – topics include Basic Math Concepts, Algebra, Trigonometry, Analytical Geometry, Discrete Math, Probability and Statistics, Calculus.
IV. THE COMPETING TEAM
- Each school is entitled to send a maximum of three (3) teams, composed of three (3) entrants and a maximum of one (1) substitute per team.
- The schools must assign a faculty member as a coach. The coach is also the team’s official representative and the only authorized person to file a protest in behalf of the entrants.
V. THE BOARD OF JUDGES (BOJ)
- The Board of Judges shall be composed of three (3) members who will convene to resolve any issue that may arise during the conduct of the competition. Members of the BOJ are professional or expert in the areas of information and communications technology, business and finance, and mathematics.
VI. MECHANICS
-
A place shall be designated for all coaches.
-
The emcee shall introduce the contestants with their coaches, members of the Board of Judges.
-
Running Scoreboard shall be displayed on the projected screen.
- Each team will be provided with a hardcopy of questions in separate sealed envelopes.
- Each team will also be provided with a ‘Submission Form’ per problem.
- When the organizer announces the start of the competition, only then can the sealed envelopes be opened.
- Each team may answer the questions in any order.
- As soon as the team finishes the problem, they will fill out the ‘Submission Form’ for that problem, and hand over to the Board of Judges (BOJ).
- The BOJ will run the stored procedure for the submitted problem against the ‘Secret Input Data’, only available to the BOJ. Note that the Input Data initially stored in each team’s database are different from the ‘Secret Input Data’ the BOJ has.
-
Answers with wrong spelling and capitalization are considered incorrect. Extra spaces before and after every data cell will be considered incorrect.
- When a team is able to solve the problem correctly, the ‘Submission Form’ will no longer be returned to the team, and they will be given a balloon corresponding to the problem solved.
- When the team has not successfully solved the problem, the ‘Submission Form’ for that problem will be returned and a 20 minute penalty will be imposed for that problem.
- The 20 minute penalty will only add to the total finished time IF the problem (where that penalty is incurred) is successfully solved.
- When the ‘Submission Form’ is returned, the BOJ will give a return remarks:
- Error: When the BOJ could not run the stored procedure because of a syntactical or a runtime error.
- Wrong Output: When there is a table cell that is not the same with the cell in the expected output, either wrong figure or wrong format.
- Time Limit Exceeded: When the stored procedure runs beyond the Limit Set for the problem; regardless of whether the answer is correct or incorrect.
-
The BOJ has the authority to override the answers on the answer keys.
-
In cases wherein a team encounters a technical problem, the team should get the attention of the emcee by raising their hand. The emcee will then allow their authorized representative or coach to attend to their concern.
-
FILING OF PROTESTS
-
Only the official coaches are allowed to file a protest.
- Protests shall be filed on official Protest Forms and shall be deliberated upon within 1 hour after the competition finished.
-
Protests made an hour after the competition finishes will not be entertained.
-
The decision of the BOJ is final and irrevocable.
-
VII. PARTICIPANTS’ TOOLS
- 1 Computer Unit
- Windows XP
- Query Browser
- Problem Sets
- 10 Sheets of Paper
- 3 Ballpens
VIII. JUDGES’ TOOLS
- 3 Computer Units
- Linux Ubuntu
- Query Browser
IX. ORGANIZERS’ TOOLS
- Two (2) LCD Projectors
- Two (2) Projector Screens
- Switch
- Database Server
- MySQL 5.1
X. SAMPLE PROBLEM SET
- Sample Problems Updated June 16, 2014
- Sample Database
Leave a Reply