What a database is in Intro to Computing - Draw & Build Visually

Draw This - beginner

Draw a simple diagram to explain what a database is. Show how data is stored in tables and how users can add, find, or update information using the database.

10 minutes

Hint 1

Hint 2

Hint 3

Grading Criteria

Diagram includes a user and a database

Database contains at least one table with rows and columns

Arrows or lines show interaction between user and database

Labels clearly identify user, database, table, and data fields

Diagram is neat and easy to understand

Solution

  +-------------------+
  |      User         |
  +---------+---------+
            |
            | 1. Add / Find / Update
            v
  +-------------------+
  |    Database       |
  |  +-------------+  |
  |  | Table:      |  |
  |  | Customers   |  |
  |  +-------------+  |
  |  | ID | Name   |  |
  |  |----|--------|  |
  |  | 1  | Alice  |  |
  |  | 2  | Bob    |  |
  |  +-------------+  |
  +-------------------+

This diagram shows a user interacting with a database. The database stores data in tables, like the 'Customers' table shown here. Each table has rows (records) and columns (fields). For example, the 'Customers' table has an ID and a Name column. The user can add new customers, find existing ones, or update their information by communicating with the database.

Think of the database as a digital filing cabinet where each table is a drawer holding related information. The user sends requests to add, find, or change data, and the database manages storing and retrieving that data efficiently.

Variations - 2 Challenges

[intermediate] Draw a diagram showing how multiple tables in a database can be related, for example, Customers and Orders tables linked by Customer ID.

[advanced] Draw a flowchart showing the steps a database takes when a user searches for a customer by name.