MoneyMatrix/bankmanagementsystemdata.sql at main · shivrajcodez/MoneyMatrix · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
create database bankmanagementsystem;

show databases;

use bankmanagementsystem;

create table signup(formno varchar(20),name varchar(20),father_name varchar(20),dob varchar(20),gender varchar(20),email varchar(30),marital_status varchar(20),address varchar(40),city varchar(25),pincode varchar(20),state varchar(25));

show tables;

select * from signup;

create table signuptwo(formno varchar(20),religion varchar(20),category varchar(20),income varchar(20),education varchar(20),occupation varchar(20),pan varchar(20),aadhar varchar(20),seniorcitizen varchar(20),existingaccount varchar(20));

select * from signuptwo;

create table signupthree(formno varchar(20),accountType varchar(40),cardnumber varchar(25),pin varchar(10),facility varchar(100));
create table login(formno varchar(20),cardnumber varchar(25),pin varchar(10));
select * from signupthree;

select * from login;

drop table bank;

create table bank(pin varchar(10),date varchar(50),type varchar(20),amount varchar(20));

select * from bank;