# Import bookshop database with pqAdmin

## Create the bookshop Database

<figure><img src="https://1749606007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXAgEjzme0UjNlyTf4TFz%2Fuploads%2FfP9l3f4lGlyOjcjvk1om%2F1742822509986.png?alt=media&#x26;token=01b8aa12-5194-4477-9471-c0092d113170" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1749606007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXAgEjzme0UjNlyTf4TFz%2Fuploads%2FTXpp5y1zWDWOzzhpOiGr%2F1742822597107.png?alt=media&#x26;token=243df1bf-043c-4cd9-a564-8b7405a1e33e" alt=""><figcaption></figcaption></figure>

## Download dump-bookshop.sql from Blackboard and choose to restore the bookshop daabase![](https://1749606007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXAgEjzme0UjNlyTf4TFz%2Fuploads%2FWitUI5SqDBjmDRALGMia%2Fimage.png?alt=media\&token=0a9f7115-244f-447c-8b89-9f7ca831c580)

<figure><img src="https://1749606007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXAgEjzme0UjNlyTf4TFz%2Fuploads%2FvihyUnVVoS5Z2jTal9v7%2Fimage.png?alt=media&#x26;token=c6492ff5-ef92-4b85-80da-6773f7d7e33c" alt=""><figcaption></figcaption></figure>

Ignore the errors, under schemas -> public -> tables, you will see 8 tables created

<figure><img src="https://1749606007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXAgEjzme0UjNlyTf4TFz%2Fuploads%2FGJlpTbecd87uNuawCDyb%2F1742832291278.png?alt=media&#x26;token=ed1724b8-7161-44bf-bcd0-5d48d0a17497" alt=""><figcaption></figcaption></figure>

## Run SQL statements

You can run SQL statements on those tables, for example you can run

```sql
SELECT * FROM authors;
```

<figure><img src="https://1749606007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXAgEjzme0UjNlyTf4TFz%2Fuploads%2FxgUqnJsrUc8eiUjgvrUo%2Fimage.png?alt=media&#x26;token=b612ea49-817c-428b-95ed-00e0477a74a2" alt=""><figcaption></figcaption></figure>
