ITD105 Semester 1 2025 – Submission Template
WARNINGS for Tasks 2-5:
Assignments that do not provide a screenshot of the results or not follow the submission instruction for a given query will be awarded Zero.
The screenshot needs to include the SQL codes, result grid and action output.
Even if your results are in the SQL file/other attached file, your grade will remain zero. We need to follow the same rule for all students. So, please make sure to include a screenshot of the result/s as requested.
Any submission that attempts to provide a screenshot that does not result from the provided query will be awarded Zero.
Even, if you are getting Error message, you can submit the screenshot of the error message and possible reason. You might still get some mark for it!
The use of artificial intelligence tools (for example Chat GPT) is not permitted in any assessment in this unit. The use of such tools when not authorised may be treated as a breach of MOPP C/5.3 Academic integrity and appropriate penalties imposed.
Task 1 [4 marks]
a) ‘GroceryProducts’ table [2 marks]
b) ‘CarRental table’ [2 marks]
Task 2 [6 marks]
In addition to the screenshots, include a SQL script. in the file named "ITD105_3B_your_student_number.sql" with your submission. Make sure it clearly shows your script. for Task 2.
Please note:
In the following tasks you will be using MySQL Workbench and any question that requires any SQL you must include a screenshot of the result from executing your query. You can make a screenshot in the following way: Windows , Mac . You can also use “Snipping Tool” to create screenshots.
The screenshot needs to include the SQL codes, result grid and action output as per the example that follows.
Task 3 [6 marks]
For each section:
The screenshot needs to include the SQL codes, result grid and action output.
Task 4 [7 marks]
For each section:
The screenshot needs to include the SQL codes, result grid and action output.
Task 5 [7 marks]
In addition to the screenshots, include a SQL script. in the file named "ITD105_3B_your_student_number.sql" with your submission. Make sure it clearly shows Task 5.
Please note:
In the following tasks you will be using MySQL Workbench and any question that requires any SQL you must include a screenshot of the result from executing your query. You can make a screenshot in the following way: Windows , Mac . You can also use “Snipping Tool” to create screenshots.
The screenshot needs to include the SQL codes, result grid and action output as per the example that follows.