p3

CREATE TABLE DEPOSIT (ACTNO VARCHAR2(5),CNAME VARCHAR2(18),BNAME
VARCHAR2(18),AMOUNT NUMBER(8,2),ADATE DATE);

Insert Data into Deposit:
INSERT INTO DEPOSIT VALUES('100','ANIL','VRCE',1000,'01-12-2020');
INSERT INTO DEPOSIT VALUES('101','SUNIL','AJNI',5000,'11-01-2020');
INSERT INTO DEPOSIT VALUES('102','MEHUL','KAROLBAGH',3500,'06-30-2020');
INSERT INTO DEPOSIT VALUES('105','PRMOD','M.G.ROAD',3000,'11-30-2020');
INSERT INTO DEPOSIT VALUES('106','SANDIP','ANDHERI',2000,'07-12-2020');
INSERT INTO DEPOSIT VALUES('107','SHIVANI','VIRAR',1000,'09-12-2021');
INSERT INTO DEPOSIT VALUES('108','KRANTI','NEHRU PLACE',5000,'02-12-2021');
INSERT INTO DEPOSIT VALUES('109','MINU','POWAI',7000,'05-16-2021');

CREATE TABLE BRANCH(BNAME VARCHAR2(18),CITY VARCHAR2(18));

Insert data into Branch:
INSERT INTO BRANCH VALUES('VRCE','NAGPUR');
INSERT INTO BRANCH VALUES('AJNI','NAGPUR');
INSERT INTO BRANCH VALUES('KAROLBAGH','DELHI');
INSERT INTO BRANCH VALUES('CHANDI','DELHI');
INSERT INTO BRANCH VALUES('DHARAMPETH','NAGPUR');
INSERT INTO BRANCH VALUES('M.G.ROAD','BANGLORE');
INSERT INTO BRANCH VALUES('ANDHERI','BOMBAY');
INSERT INTO BRANCH VALUES('VIHAR','BOMBAY');
INSERT INTO BRANCH VALUES('NEHRU PLACE','DELHI');
INSERT INTO BRANCH VALUES('POWAI','BOMBAY’);

Insert data into customers:
INSERT INTO CUSTOMERS VALUES ('ANIL','CALCUTTA');
INSERT INTO CUSTOMERS VALUES ('SUNIL','DELHI');
INSERT INTO CUSTOMERS VALUES ('MEHUL','BARODA');
INSERT INTO CUSTOMERS VALUES ('MANDAR','PATNA');
INSERT INTO CUSTOMERS VALUES ('MADHURI','NAGPUR');
INSERT INTO CUSTOMERS VALUES ('PRAMOD','NAGPUR');
INSERT INTO CUSTOMERS VALUES ('SANDIP','SURAT');
INSERT INTO CUSTOMERS VALUES ('SHIVANI','BOMBAY');
INSERT INTO CUSTOMERS VALUES ('KRANTI','BOMBAY');
INSERT INTO CUSTOMERS VALUES ('NAREN','BOMBAY');

.CREATE TABLE BORROW(LOANNO VARCHAR2(5),CNAME VARCHAR2(18),BNAME
VARCHAR2(18),AMOUNT NUMBER(8,2));

Insert data into Borrow:
INSERT INTO BORROW VALUES ('201','ANIL','VRCE',1000);
INSERT INTO BORROW VALUES ('206','MEHUL','VRCE',5000);

List all data from table DEPOSIT.
➢ Select *from Deposit;

4. List all data from table BORROW.
   ➢ Select *from Borrow;

5. List all data from table CUSTOMERS.
   ➢ Select *from Customers;

6. List all data from table BRANCH.
   ➢ Select *from Branch;

7. Give account no and amount of depositors.
   ➢ Select actno,amount_number from Deposit;

8. List all data from SAILORS.
   ➢ Select *from Sailors;

9. List Boat Name and its color.
   ➢ Select boat_Name,boats_color from boats;

10. List Employee name and its city.
    ➢ Select emp_name,City from employee;

11. List all the details of Clients.
    ➢ Select *from Clients;

12. Describe various products and its rating.
    ➢ Select dscr, sell_price, cost_price from Products;

13. Describe sailors name, age and its rating.
    ➢ Select Sname, Age, Rating from Sailors;

14. Describe the managers of various employee.
    ➢ Select Emp_nman_name from Employees;

15. Describe the detail of Loan for customers.
    ➢ select * from Borrow;

16. Describe the date of travel of various sailors.
    ➢ Select SID, day from Travel;
    INSERT INTO BORROW VALUES ('311','SUNIL','DHARAMPETH',3000);
    INSERT INTO BORROW VALUES ('321','MADHURI','ANDHERI',2000);
    INSERT INTO BORROW VALUES ('375','PRMOD','VIHAR',8000);
    INSERT INTO BORROW VALUES ('481','KRANTI','NEHRU PLACE',3000);