Database systems

Assignment 3 - Presentation

Install MySQL Workbench on your PC

Please read instructions in the subject outline

Assignment 3 - Presentation of queries Step 1 After getting the correct answer to each question;

1. Copy and paste your SQL code into a Word document for each question, as the example below:

Q-1:

SELECT event_code

FROM prize

WHERE place=1

AND prizemoney BETWEEN 100 AND 200;

SQL Help, by: Antoinette Cevenini - 2016

Presentation of queries step 2 - Continued …

2. Do a screenshot (ALT+PRTSCN) of your SQL code and paste under the copied SQL code for each question into a Word document, as the example below: Q-1:

SELECT event_code

FROM prize

WHERE place=1

AND prizemoney BETWEEN 100 AND 200;

Step 2- The screenshot

SQL Help, by: Antoinette Cevenini - 2016

Presentation of queries step 3 Continued … 3. Copy the results only then paste under the screenshot in your Word document for each question, as shown below: Q-1:

SELECT event_code

FROM prize

WHERE place=1 AND prizemoney BETWEEN 100 AND 200;

event_code

0101

0103

Step 3- The results

SQL Help, by: Antoinette Cevenini - 2016

Presentation of queries- complete for each question Q-1:

SELECT event_code

FROM prize

WHERE place=1 AND prizemoney BETWEEN 100 AND 200;

event_code

0101

0103

Step 3- The results

Step 2- The screenshot

Step 1- The code

SQL Help, by: Antoinette Cevenini - 2016