# Explore a database

2.4
In this course, you’re going to explore a modified database which tracks computer sales using SQL. To access and change the data in a database, you will need to use a software package known as a database management system or DBMS. I’m going to instal DB browser for SQLite, but you can also use an online DBMS, such as sqliteonline.com Click Open the Database, and open the previously downloaded computer sales file.
40.1
And here you can see the different tables within our database, so we have manufacturer, model, and sales. And you can start to see what data is in those tables. We can also browse data, and when we browse the data, we can see what’s inside those two tables. So, for example, manufacturer, we have the name.
72
So we’ve got Raspberry Pi, Apple, and Commodore. In the Models table, we can see that we’ve got the different model names. So for example, we’ve got the first ever Raspberry Pi all the way down to the most recent one, Raspberry Pi 4, and we’ve got a couple of Pi zeros, Apples, and the Commodores ended in Amiga 500. Are you up for a challenge? Look through the data in the database and see if you can find the computer which has the least amount of RAM from a company which is still trading. Share your answers and describe how you found the data in the comments below.

During this course you will be exploring and modifying an example database that tracks computer sales.

### Computer sales database

The computer sales database you will be using is an SQLite relational database.

SQLite databases are stored in single, self-contained files. SQLite is the most widely used database in the world, partly because it’s very simple to use and has very low hardware and software overheads. In computing, an overhead refers to the processing time required by hardware or software. Other relational databases are MySQL, PostgreSQL, Access, and SQL Server.

In this step, you will explore the structure and contents of the computer sales database and see how a database can be used to store specific information.

### Browse the database

To access a database, you need to use a software package known as a database management system (DBMS). The DBMS is used to define, manipulate, retrieve, and manage data in a database. Most databases come with their own DBMS software.

You will need to use an SQLite DBMS during this course. I recommend using either:

1. Download and install DB Browser for SQLite or open SQLite Online.

If you are using DB Browser:

3. Click Open Database and select the computer_sales.db file you downloaded.

When the database is open, you will see three tables, manufacturer, model, and sales, in the Database Structure tab.

4. Click on the Browse Data tab and select a Table to see the contents of the database.

If you are using SQLite Online:

3. Click File, then Open DB and select the computer_sales.db file you downloaded.

When the database is open, you will see three tables, manufacturer, model, and sales, in the Table section under SQLite.

4. Right-click on the name of a table and click SELECT (Show table) to see the contents of the database.

### Challenge

By looking through the data in the database, can you find the computer that has the least amount of RAM from a company that is still trading?

In the comments section, describe how you found the data.