@DEEPASHREE_Ramesh2207

code123

updated September 17, 2021 · SQL
CREATE TABLE Customer_Details (
  Customer_ID char(5) PRIMARY KEY check(Customer_ID like 'C%'),Customer_Name varchar(40) ,Customer_addr varchar(50)
);
INSERT INTO Customer_Details VALUES('C001','SURABHI AGARWAL','MANIKCHAND GALERIA'),
('C002','JOHN MATHEW','KOTHRUDE'),
('C003','RICHA SHARMA','MG ROAD'),
('C004','SARIKA SAXENA','CAMP'),
('C005','AKSHAY TIWARI','KHAR'),
('C006','SUMIT SAXENA','KHAR'),
('C007','RASHMI JAIN','CAMP PUNE');

CODE 4

September 16, 2021 · SQL
create table Account_Details(
         Account_ID char(5) primary key not null, 
         Customer_ID char(5) ,
         Branch_ID char(5) ,
         Account_Type char(1),
         Deposit_Amount int,
         Acc_opening_date date
);
         
insert into Account_Details values('A010','C001','B101','S','30000',2021-05-10),
('A020','C002','B102','S','23000',2021-05-19),('A030','C003','B103','C','2000',2021-05-25),

CODE 3

September 16, 2021 · SQL
create table Account_Details(
         Account_ID char(5) primary key not null, 
         Customer_ID char(5) ,
         Branch_ID char(5) ,
         Account_Type char(1),
         Deposit_Amount int,
         Acc_opening_date date
);
         
insert into Account_Details values('A010','C001','B101','S','30000',2021-05-10),
('A020','C002','B102','S','23000',2021-05-19),('A030','C003','B103','C','2000',2021-05-25),

CODE1

September 16, 2021 · SQL
CREATE TABLE Bank_Details (
  Branch_ID char(5) PRIMARY KEY check(Branch_ID like 'B%'),Branch_Location varchar(50),Branch_city(50)
);

INSERT INTO Bank_Details VALUES('B101','Peralam','TN'),('B102','Kollumangudi','TVR'), 
                               ('B103','Camp','Mumbai'),('B104','US','West US'), 
                               ('B105','MG Road','MYLD'),('B106','Kothrude','Pune'), 
                               ('B107','Galeria','Pune'),('B108','AKLR','MYLD'), 
                           

code 1

September 16, 2021 · SQL
create table Bank_Details(
        Branch_ID char(5) primary key not null,
        Branch_Location varchar(50),
        Branch_city varchar(50));
        
insert into Bank_Details values('B101','Peralam','TN'),('B102','Kollumangudi','TVR'),
                               ('B103','Camp','Mumbai'),('B104','US','West US'),
                               ('B105','MG Road','MYLD'),('B106','Kothrude','Pune'),
                               ('B107','Galeria','Pune'),('B108','AKLR','MYLD'),