Scribd
Upload
61 views2 pages

Loan Insertion in Banking Database

This document defines the schema for a banking database with tables for banks, branches, accounts, loans, and clients. It creates each table with the appropriate fields, primary keys, and foreign key constraints. It then populates each table with sample data by executing multiple INSERT statements. Finally, it runs SELECT statements to view the contents of each table.

Uploaded by

Vedika Singh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
61 views2 pages

Loan Insertion in Banking Database

This document defines the schema for a banking database with tables for banks, branches, accounts, loans, and clients. It creates each table with the appropriate fields, primary keys, and foreign key constraints. It then populates each table with sample data by executing multiple INSERT statements. Finally, it runs SELECT statements to view the contents of each table.

Uploaded by

Vedika Singh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1.

CREATE TABLE BANK(


2. bank_ID numeric primary key,
3. bank_name varchar(20) not null,
4. bank_address varchar(20)
5. );
6. INSERT INTO BANK VALUES(001,'SBI','Godha colony');
7. INSERT INTO BANK VALUES(002,'PNB','Rajwada');
8. INSERT INTO BANK VALUES(003,'MET','Geeta colony');
9. INSERT INTO BANK VALUES(004,'SWISS','Baker street');
[Link] INTO BANK VALUES(005,'NXI','Putin Hall');
[Link] * FROM BANK ;

[Link] TABLE BRANCH(


13.bank_ID numeric,
14.branch_ID numeric primary key,
15.branch_name varchar(20) not null,
16.branch_address varchar(20), FOREIGN KEY(bank_ID) REFERENCES BANK);
[Link] INTO BRANCH VALUES(001,101,'Delhi','Gandhi Nagar');
[Link] INTO BRANCH VALUES(002,102,'Punjab','Chandigarh');
[Link] INTO BRANCH VALUES(003,103,'M.P','Vijay Nagar');
[Link] INTO BRANCH VALUES(004,104,'Bangalore','Thullianadammm');
[Link] INTO BRANCH VALUES(005,105,'Assam','Kaziranga');
[Link] * FROM BRANCH ;

[Link] TABLE ACCOUNT(


24.account_ID numeric primary key,
25.branch_ID numeric,
[Link] varchar(20) not null,
27.account_type varchar(20) not null,
[Link] KEY(branch_ID) REFERENCES BRANCH);
[Link] INTO ACCOUNT VALUES(201,101,'Rajeev','Salary account');
[Link] INTO ACCOUNT VALUES(202,102,'Ravnish','Saving account');
[Link] INTO ACCOUNT VALUES(203,103,'Naseeb','Fixed deposit account');
[Link] INTO ACCOUNT VALUES(204,104,'Ashish','Recurring deposit
account');
[Link] INTO ACCOUNT VALUES(205,105,'Tanmay','NRI account');
[Link] * FROM ACCOUNT ;

[Link] TABLE LOAN(


36.account_ID numeric,
37.loan_ID numeric primary key,
[Link] varchar(20) not null,
39.loan_type varchar(20) not null,
40.loan_amount numeric,
[Link] KEY(account_ID) REFERENCES ACCOUNT);
[Link] INTO LOAN VALUES(201,301,'Rajeev','Personal loan',10000);
[Link] INTO LOAN VALUES(202,302,'Ravnish','Home loan',20000);
[Link] INTO LOAN VALUES(203,303,'Naseeb','Car loan',15000);
[Link] INTO LOAN VALUES(204,304,'Ashish','Education loan',25000);
[Link] INTO LOAN VALUES(205,305,'Tanmay','Business loan',30000);
[Link] * FROM LOAN ;

[Link] TABLE CLIENT(


49.account_ID numeric,
50.client_ID numeric primary key,
[Link] varchar(20) not null,
52.client_address varchar(500) not null,
[Link] KEY(account_ID) REFERENCES ACCOUNT);
[Link] INTO CLIENT VALUES(201,401,'Rajeev','21,Gandhi Nagar');
[Link] INTO CLIENT VALUES(202,402,'Ravnish','16,Vijay Nagar');
[Link] INTO CLIENT VALUES(203,403,'Sumit','13,Geeta colony');
[Link] INTO CLIENT VALUES(204,404,'Naseeb','11, Savedh Nagar');
[Link] INTO CLIENT VALUES(205,405,'Tanmay','07,godha colony');
[Link] * FROM CLIENT ;

You might also like