INF3707 Assignment 1 solution 2025

Question 1 First things first, before you start with your assignment, make sure that your MySQL server and MySQL Workbench are installed and working. The prescribed book provides the procedures for doing this in appendix A (Windows) and B (macOS). The appendices were uploaded to Additional Resources on myUnisa. Secondly, on myUnisa, under Additional Resources, download the folder mgs_ex_starts, it contains some script files that you need for this assignment and other assignments, 2, 3 and 4. In the mgs_ex_starts folder, use the script file create_my_guitar_ to create the My Guitar Shop database. After running the scripts, the Output window displays messages that indicate whether the script was executed successfully. Take the screenshot, and paste it on your answer sheet to show that the database is installed correctly. The screenshot should show the My Guitar Shop database schema on your Workbench. View the data contained in the Categories table. To view the Categories table data, run a select query. Take the screenshot of the query and the output, and paste it on your answer sheet. Navigate through the database objects and view the column definition for the Categories table. Take the screenshot of the column definition and paste it on your answer sheet. Write a SELECT statement that returns four columns from the Products table: product_code, product_name, list_price, and discount_percent. Add an ORDER BY clause to this statement to sort the result by list_price in descending order. Take the screenshot of the query and the output and paste it on your answer sheet. Write a SELECT statement that returns the product_name and list_price columns from the Products table. Return one row for each product that has the same list price as another product. Hint: Use a self-join to check that the product_id columns aren't equal but the list_price columns are equal. Order the output by the product_name column. Take the screenshot of the query and the output and paste on your answer sheet