Prof. Price Lab 4 - SQLite Database
Class: CYBR-405
Notes:
Q1
What year did Aggie Bonfire become a tradition?
Go to the Traditions table and search for the Aggie Bonfire entry:
/CYBR-405/Labs/Lab%20Writeups/Visual%20Aids/image.png)
Answer: 1909
Q2
What is the last name of the person who is not a former president of TAMU?
Go to the Presidents table and search for a name and last name that are not part of the official former presidents lists:
/CYBR-405/Labs/Lab%20Writeups/Visual%20Aids/image-1.png)
Answer: Harris
Q3
What year did the newest (most recent) tradition begin?
Go to the Traditions table and click on the Year column twice in order to filter by most recent year:
/CYBR-405/Labs/Lab%20Writeups/Visual%20Aids/image-2.png)
Answer: 1998
Q4
Who is the opponent for the football game on Oct 26?
Go to the Game Day table and look for the Oct 26 entry:
/CYBR-405/Labs/Lab%20Writeups/Visual%20Aids/image-3.png)
Answer: LSU
Q5
According to the definitions table, Aggies “hiss” when something is___ ?
Go to the Definitions table and look for the Hiss entry:
/CYBR-405/Labs/Lab%20Writeups/Visual%20Aids/image-4.png)
Answer: Bad
Q6
How many weeks is Bonfire cut?
Go to the Bonfire table and look for the Cut / load entry:
/CYBR-405/Labs/Lab%20Writeups/Visual%20Aids/image-5.png)
Answer: 4
Q7
On the Pictures table, what is the last name (one word) of the famous person displayed in the Who? BLOB data?
Go to the Pictures table and click on the BLOB cell on the Who? entry to see the image:
/CYBR-405/Labs/Lab%20Writeups/Visual%20Aids/image-6.png)
Answer: Reveille
Q8
What is the last name of the current president of TAMU?
This info is not on the database so I searched on Google.
As of October 3, 2025, former Texas State Senator Tommy Williams serves as the interim president of Texas A&M University. He was appointed by the Texas A&M University System Board of Regents following the resignation of Mark A. Welsh III, who stepped down in September 2025.
- Interim President: Tommy Williams (appointed Oct 2025).
- Predecessor: Gen. Mark A. Welsh III (resigned Sept 2025).
- Context: The leadership change followed controversy regarding a professor's termination over a classroom discussion on gender identity.
Answer: Williams
Q9
How many days does the FINISH stage for Bonfire require?
Go to the Bonfire table and look for the Finish entry:
/CYBR-405/Labs/Lab%20Writeups/Visual%20Aids/image-7.png)
Answer: 1
Q10
What does the "c" stand for in the definition of a c.t.?
Go to the Definitions table and look for the c.t. entry:
/CYBR-405/Labs/Lab%20Writeups/Visual%20Aids/image-8.png)
Answer: Cadet