Changes between Version 2 and Version 3 of OtherTopics

Timestamp:

07/15/26 10:50:43 (13 days ago)

Author:

216009

Comment:

--

OtherTopics

@@ -211 +211 @@
 '''Results in details / description:'''
  * **Query Analysis Synthesis**: I mapped out a highly complex aggregate query (Report 3) that joins student, student_subject, and subject tables to calculate GPA. I used the AI to help me generate a realistic technical breakdown of PostgreSQL execution trees (EXPLAIN plans) to visually demonstrate the performance jump when shifting from standard sequential scans to B-Tree index scans.
- * **Security Framework Documentation**: I reviewed my DAO pattern with the AI to explain the security boundaries I chose. The assistant helped me describe how my systematic use of Java’s PreparedStatement parameters inherently sanitizes incoming strings and completely drops SQL injection risks.
+ * **Security Framework Documentation**: I reviewed my DAO pattern with the AI to explain the security boundaries I chose. The assistant helped me describe how my systematic use of Java’s Prepared Statement parameters inherently sanitizes incoming strings and completely drops SQL injection risks.
  * **Formatting Adjustment**: The AI assisted in organizing my analytical statistics, query indexes, and safety protocols into clean, compliant Trac Wiki markup panels.