Opening the staff database
For this exercise we will be using the 'staff' database. You can download it from this link
Right-click on the link above and select 'Save Link As'. Save the file to your Home directory or to another appropriate location on your computer.
To open the database in DB Browser do the following;
- click on the 'open database' button in the toolbar.
- Navigate to where you have stored the database file on your local machine, select it and click open.
When you open the database, the 'Database Structure' tab on the left andthe 'DB Schema' pane on the right will look very similar to eachother. However the 'DB Schema' pane is only there to allow you to see the details of the schema for the tables. In particular what tables are in the database and the fields and their types which are in each table.
The 'Database Structure' tab on the left allows you to initiate actions on the tables. If you right click on a table name in the 'DB Schema' pane, nothing happens. However, if you do the same in the 'Database Structure' menu you will be given a set of possible actions. These are the same actions that are available from the toolbar at the top of the tab.
If you select 'Browse Table', the data from the table is loaded into the 'Browse Data' pane from where it can be examined or filtered. You can also select ther table you wish to Browse directly from here.