CODE1

DEEPASHREE_Ramesh2207 · 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'), 
                               ('B109','SNTGD','MYLD'),('B110','KHAR','Mumbai'); 

select * from Bank_Details;

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');

select * from Customer_Details;

Comments

Please sign up or log in to contribute to the discussion.