Untitled
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>