DBMS full practical solution

D://Jay-pc/dbms-prac/dbms.pkh
/*Practical 1 : Studying DDL-create and DML-insert commands*/
/* (i) Creating table according to the following defination*/

create table deposit_e1(actno varchar(15),cname varchar(18), bname varchar(18), amount number(8,2),
adate date);
create table branch_e1(bname varchar(15), city varchar(15));
create table customers_e1(cname varchar(15), city varchar(15));
create table borrow_e1(loanno varchar(15), cname varchar(15), bname varchar(15), amount number(8,2));

/* (ii) Inserting data into the table */

/*"deposit" table commands*/
insert into deposit_e1 values('100','Anil','vrce','1000.00','1-MAR-95');
insert into deposit_e1 values('101','Sunil','ajni','5000.00','4-JAN-96');
insert into deposit_e1 values('102','Mehul','karolbagh','3500.00','17-NOV-95');
insert into deposit_e1 values('104','Madhuri','chandi','1200.00','17-DEC-95');
insert into deposit_e1 values('105','Prmod','m.g. road','3000.00','27-MAR-96');
insert into deposit_e1 values('106','Sandip','andheri','2000.00','31-MAR-96');
insert into deposit_e1 values('107','Shivani','virar','1000.00','05-SEP-95');
insert into deposit_e1 values('108','Kranti','nehru place','5000.00','02-JUL-95');
insert into deposit_e1 values('109','Minu','powai','7000.00','10-AUG-95');



/*"branch" table commands*/
insert into branch_e1 values('vrce','nagpur');
insert into branch_e1 values('ajni','nagpur');
insert into branch_e1 values('karolbagh','delhi');
insert into branch_e1 values('chandi','delhi');
insert into branch_e1 values('dharampeth','nagpur');
insert into branch_e1 values('m.g. road','banglore');
insert into branch_e1 values('andheri','bombay');
insert into branch_e1 values('virar','bombay');
insert into branch_e1 values('nehru place','delhi');
insert into branch_e1 values('powai','bombay');

/*"customers" table commands*/
insert into customers_e1 values('Anil','calcutta');
insert into customers_e1 values('Sunil','delhi');
insert into customers_e1 values('Mehul','baroda');
insert into customers_e1 values('Mandar','patna');
insert into customers_e1 values('Madhuri','nagpur');
insert into customers_e1 values('Pramod','nagpur');
insert into customers_e1 values('Sandip','surat');
insert into customers_e1 values('Shivani','bombay');
insert into customers_e1 values('Kranti','bombay');
insert into customers_e1 values('Naren','bombay');

, D://Jay-pc/dbms-prac/dbms.pkh




/*"borrow" table commands*/
insert into borrow_e1 values('201','Anil','vrce','1000.00');
insert into borrow_e1 values('206','Mehul','ajni','5000.00');
insert into borrow_e1 values('311','Sunil','dharampeth','3000.00');
insert into borrow_e1 values('321','Madhuri','Andheri','2000.00');
insert into borrow_e1 values('375','Prmod','virar','8000.00');
insert into borrow_e1 values('481','Kranti','nehru place','3000.00');

/*List of queries (Draw the output of queries accordingly)*/

/*(1)*/ describe deposit_e1;
describe branch_e1;