SQL as the query language in Intro to Computing - Draw & Build Visually

Draw This - beginner

Draw a flowchart that shows the process of using SQL to retrieve all records from a table named 'Employees'. The flowchart should start from the user writing a query, then the database processing it, and finally displaying the results.

7 minutes

Hint 1

Hint 2

Hint 3

Hint 4

Grading Criteria

Start and End symbols present

Process box for writing the SQL query included

Process box for database processing included

Process box for displaying results included

Flow arrows correctly connect all steps in order

Solution

  +-------+
  | Start |
  +-------+
      |
      v
+-------------------------+
| Write SQL query:         |
| SELECT * FROM Employees; |
+-------------------------+
      |
      v
+-------------------------+
| Database processes query |
+-------------------------+
      |
      v
+-------------------------+
| Display all employee     |
| records to user          |
+-------------------------+
      |
      v
  +-----+
  | End |
  +-----+

This flowchart starts with the user writing the SQL query to select all records from the 'Employees' table. Then, the database processes this query internally. Finally, the results (all employee records) are displayed to the user. The flowchart uses simple process boxes and clear flow arrows to show the sequence.

Variations - 2 Challenges

[intermediate] Draw a flowchart for using SQL to find employees with a salary greater than 50000 from the 'Employees' table.

[advanced] Draw a flowchart for using SQL to update the salary of an employee with ID 101 to 60000 in the 'Employees' table and then display the updated record.