Untitled

mail@pastecode.io avatarunknown
plain_text
22 days ago
1.8 kB
9
Indexable
Never
Enter password: **********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.1.0 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database dbms;
Query OK, 1 row affected (0.03 sec)

mysql> use dbms;
Database changed
mysql> create table branch(
    -> branchName varchar(100) primary key,
    -> branchCity varchar(100),
    -> assets varchar(100));
Query OK, 0 rows affected (0.05 sec)

mysql> create table account(
    -> accountNumber varchar(100) primary key,
    -> branchName varchar(100),
    -> balance varchar(100));
Query OK, 0 rows affected (0.02 sec)

mysql> create table depositer(
    -> customerName varchar(100) primary key,
    -> accountNumber varchar(100));
Query OK, 0 rows affected (0.02 sec)

mysql> create table customer(
    -> customerName varchar(100) primary key,
    -> customerStreet varchar(100),
    -> customerCity varchar(100));
Query OK, 0 rows affected (0.03 sec)

mysql> create table loan(
    -> loanNumber varchar(100) primary key,
    -> branchName varchar(100),
    -> amount varchar(100));
Query OK, 0 rows affected (0.02 sec)

mysql> create table borrower(
    -> customerName varchar(100) primary key,
    -> loanNumber varchar(100));
Query OK, 0 rows affected (0.02 sec)

mysql> show tables;
+----------------+
| Tables_in_dbms |
+----------------+
| account        |
| borrower       |
| branch         |
| customer       |
| depositer      |
| loan           |
+----------------+
6 rows in set (0.00 sec)

mysql>