Changes between Version 1 and Version 2 of InstructionsP9

Timestamp:

02/03/26 15:47:43 (5 days ago)

Author:

vangel.ajanovski

Comment:

—

InstructionsP9

@@ -5 +5 @@
 * Other topics (propose for approval). 
 
-More details soon… 
+Create a wiki page called **OtherTopics** and use the structure from this template:
+
+{{{#!box information
+
+= Other Topics 
+
+** SQL Performance **
+
+Document performance analysis for each complex query that you have produced:
+
+* Propose indexes that could improve the performance of the query.
+* Document performance analysis using EXPLAIN PLAN to execute the query before the creation of the indexes, and after the creation of the indexes.
+* Document whether the indexes were truly used in the execution plan
+* Conclusion about the performance gains
+
+** Security measures **
+
+* Document the security measures you have introduced in your application related to database access (prevention of SQL injection, prevention of un-authorized access to data, ...)
+
+* Document the security measures you have introduced in your database related to database access (prevention of SQL injection in dynamic queries, prevention of un-authorized access to data, ...)
+
+** Other developments **
+
+...
+
+}}}
+
+
+**AI Use**
+
+You are free to use an AI to improve your work, provided that you adhere to the following rules:
+
+ * you use AI in this phase of the project only to improve your own initial work
+ * you use AI to create alternative ideas, that you can learn from and borrow and use in your own work
+ * you document the changes you have made to your own work based on the ideas from the AI tool in the history above
+ * you document the entire usage of the AI tool in a new wiki page named **OtherTopicsAIUsage** linked here, that you structure according to the following template
+
+{{{#!box information
+
+= Other Topics AI Usage
+
+**Name of AI service/solution that was used**
+
+URL:
+
+Type of service/subscription: 
+
+**Final result**
+
+Diagram:
+
+Results in details / description:
+
+**Entire AI usage log**
+
+ 1. Line-by-line Log of all interactions with the AI (prompt and response) 
+ 2. ...
+
+}}}
+