---
title: "SQL: create and use bank database"
subject: "Database Management System"
chapter: 3
key: "semester_6/database_management_system:sql-create-database-bank"
source: https://www.bctengineer.com/q/semester_6/database_management_system/sql-create-database-bank
site: BCT Engineering
---

# SQL: create and use bank database

Database Management System · Chapter 3: Relational Languages & Relational Model

- Asked in: year not given
- Video: [MySQL: How to create a DATABASE](https://www.youtube.com/watch?v=9LQ9rGoGfYQ) — Bro Code
- Answer checked by Claude Opus 5.5 (high effort) on 2026-10-14
- Page: https://www.bctengineer.com/q/semester_6/database_management_system/sql-create-database-bank
- Whole chapter: https://www.bctengineer.com/md/semester_6/database_management_system/chapter-3

## Question

Consider database schema:
Account (acc_no, branch_name, balance)
Branch (branch_name, branch_city, assets)
Customer (customer_name, customer_street, customer_city)
Loan (loan_no, branch_name, amount)
Depositor (customer_name, acc_no)
Borrower (customer_name, loan_no)
Create database and list existing databases. Use database bank for above schema.

## Short answer

Use CREATE DATABASE bank; then SHOW DATABASES; to list databases, then USE bank; to select it. MySQL replies Database changed after USE.

## Answer

The statements below use MySQL syntax.

#### Create the database
```sql
CREATE DATABASE bank;
```

#### List existing databases
```sql
SHOW DATABASES;
```
Sample output:
```text
+--------------------+
| Database           |
+--------------------+
| bank               |
| information_schema |
| mysql              |
+--------------------+
```

#### Use the database
```sql
USE bank;
```
MySQL replies `Database changed`. Every table created after this statement is stored inside bank.

#### Notes
- `CREATE DATABASE IF NOT EXISTS bank;` avoids an error if bank already exists.
- In PostgreSQL the same steps are `CREATE DATABASE bank;`, `\l` to list and `\c bank` to connect. In SQL Server they are `CREATE DATABASE bank;`, `SELECT name FROM sys.databases;` and `USE bank;`.

## Check yourself

The answer's key points as multiple-choice questions, with the correct option and why.

1. Which statement creates the database?
   A. MAKE DATABASE bank;
   B. SHOW DATABASE bank;
   C. CREATE DATABASE bank;
   D. USE bank;
   Answer: C. CREATE DATABASE creates it. (Key point: Create)

2. What does USE bank; do?
   A. Creates bank
   B. Deletes bank
   C. Selects bank so later tables are created inside it
   D. Lists tables
   Answer: C. It sets the current database. (Key point: USE)

## Close variants set in other exams

- [SQL: customer name and address](https://www.bctengineer.com/question.md?key=semester_6%2Fdatabase_management_system%3Asql-customer-name-address) — Database Management System, chapter 3

## Related in Database Management System

- [SQL: create tables for bank schema](https://www.bctengineer.com/question.md?key=semester_6%2Fdatabase_management_system%3Asql-create-tables-bank) — Database Management System, chapter 3
- [SQL: branch city with assets over 1000000](https://www.bctengineer.com/question.md?key=semester_6%2Fdatabase_management_system%3Asql-branch-assets-million) — Database Management System, chapter 3
- [SQL: customer, branch, account details](https://www.bctengineer.com/question.md?key=semester_6%2Fdatabase_management_system%3Asql-natural-join-details) — Database Management System, chapter 3
- [SQL: customers with account in Dharan](https://www.bctengineer.com/question.md?key=semester_6%2Fdatabase_management_system%3Asql-customers-dharan-branch) — Database Management System, chapter 3
- [SQL: customer names beginning with su](https://www.bctengineer.com/question.md?key=semester_6%2Fdatabase_management_system%3Asql-customer-name-like-su) — Database Management System, chapter 3
- [SQL: number of accounts per branch](https://www.bctengineer.com/question.md?key=semester_6%2Fdatabase_management_system%3Asql-count-accounts-branch) — Database Management System, chapter 3