Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Lab exercise in bharathiyar university 2020 bba
Typology: Lab Reports
1 / 63
This page cannot be seen from the preview
Don't miss anything!
S.NO Date Name of the Program Pi Page No Signature 1 Design a database for student
pay. 16 Design a database for bank information. 17 Insert records for bank database table. 18 Create a view for an employee with their deposit information. 19 Write a stored function to find net balance of a customer. 20 Write a PL/SQL procedure to deposit amount to bank database
Program No: 1 DESIGN A DATABASE FOR STUDENT INFORMATION Date: Aim: Algorithm:
Program No: 2 INSERT RECORD FOR STUDENT DATABASE Date: Aim: Algorithm:
Queries: SQL> CREATE TABLE STUDENTSBBA2(ROLLNUMBER NUMBER(20),NAME VARCHAR(20),CLASS VARCHAR(20),malayalam number(3),english number(3),maths number(3),science number(3), total number(3),percentage number(3),pass_or_fail varchar(10)); Table created. SQL> INSERT INTO STUDENTSBBA2 VALUES ('&rollnumber','&name','&class','&malayalam','&english','&maths ','&science','&total','&percentage','&pass_or_fail'); Enter value for rollnumber: 123456 Enter value for name: KEERTHANA Enter value for class: III BBA Enter value for malayalam: 80 Enter value for english: 50 Enter value for maths: 20 Enter value for science: 100 Enter value for total: 0 Enter value for percentage: 0 Enter value for pass_or_fail: old 1: INSERT INTO STUDENTSBBA2 VALUES ('&rollnumber','&name','&class','&malayalam','&english','&m new 1: INSERT INTO STUDENTSBBA2 VALUES ('123456','KEERTHANA','III BBA','80','50','20','100','0',' 1 row created. SQL> / Enter value for rollnumber: 987456 Enter value for name: SARANYA Enter value for class: III BBA Enter value for malayalam: 90 Enter value for english: 50 Enter value for maths: 60 Enter value for science: 80 Enter value for total: 0 Enter value for percentage: 0 Enter value for pass_or_fail: old 1: INSERT INTO STUDENTSBBA2 VALUES ('&rollnumber','&name','&class','&malayalam','&english','&m new 1: INSERT INTO STUDENTSBBA2 VALUES ('987456','SARANYA','III BBA','90','50','60','80','0','0',' 1 row created.
Program No: 3 ALTER A FIELD SIZE IN THE STUDENT DATABASE TABLE Date: Aim: Algorithm:
Queries: SQL> CREATE TABLE STUDENTS1(ROLLNUMBER NUMBER(20),NAME VARCHAR(20),CLASS VARCHAR(20),malayalam number(3),english number(3),maths number(3),science number(3), total number(3),percentage number(3),pass_or_fail varchar(10)); SQL> desc students1; Name Null? Type
ROLLNUMBER NUMBER(20) NAME VARCHAR2(20) CLASS VARCHAR2(20) MALAYALAM NUMBER(3) ENGLISH NUMBER(3) MATHS NUMBER(3) SCIENCE NUMBER(3) TOTAL NUMBER(3) PERCENTAGE NUMBER(3) PASS_OR_FAIL VARCHAR2(10) SQL> alter table students1modify rollnumber number(30); Table altered. SQL> desc students1; Output: Name Null? Type
ROLLNUMBER NUMBER(30) NAME VARCHAR2(20) CLASS VARCHAR2(20) MALAYALAM NUMBER(3) ENGLISH NUMBER(3) MATHS NUMBER(3) SCIENCE NUMBER(3) TOTAL NUMBER(3) PERCENTAGE NUMBER(3) PASS_OR_FAIL VARCHAR2(10) RESULT: Program No: 4 DELETE A FIELD IN THE STUDENT DATABASE TABLE
VARCHAR(20),CLASS VARCHAR(20),malayalam number(3),english number(3),maths number(3),science number(3), total number(3),percentage number(3),pass_or_fail varchar(10)); SQL> insert into students1 values('&rollnumber','&name','&class','&malayalam','&english','&maths','& science','&total','&percentage','&pass_or_fail'); Enter value for rollnumber: 123456789 Enter value for name: swoorupan Enter value for class: III bba Enter value for malayalam: 85 Enter value for english: 85 Enter value for maths: 100 Enter value for science: 99 Enter value for total: 0 Enter value for percentage: 0 Enter value for pass_or_fail: old 1: insert into students1 values('&rollnumber','&name','&class','&malayalam','&english','&maths new 1: insert into students1 values('123456789','swoorupan','III bba','85','85','100','99','0','0' 1 row created. SQL> / Enter value for rollnumber: 987456321 Enter value for name: vicky Enter value for class: III bba Enter value for malayalam: 65 Enter value for english: 52 Enter value for maths: 56 Enter value for science: 84 Enter value for total: 0 Enter value for percentage: 0 Enter value for pass_or_fail: old 1: insert into students1 values('&rollnumber','&name','&class','&malayalam','&english','&maths new 1: insert into students1 values('987456321','vicky','III bba','65','52','56','84','0','0',' ' 1 row created. SQL> select * from students1; ROLLNUMBER NAME CLASS MALAYALAM ENGLISH
123456789 swoorupan III bba 85 85 100 99 0 0 987456321 vicky III bba 65 52 56 84 0 0 **SQL> delete from students1 where name='vicky'; 1 row deleted. SQL> select * from students1; Output: ROLLNUMBER NAME CLASS MALAYALAM ENGLISH
MATHS SCIENCE TOTAL PERCENTAGE PASS_OR_FA
123456789 swoorupan III bba 85 85 100 99 0 0 RESULT: Program No: 5 SELECT RECORDS WITH ROLL NUMBER, NAME, CLASS,**
SQL> create table san(rollnumber number(20),name varchar(20),class varchar(20),malayalam number(3),english number(3),maths number(3),science number(3),total number(3),percentage number(3),pass_or_failvarchar(10),Malayalam_sub_pass_percentage number(3)); Table created. SQL> INSERT INTO san VALUES ('&rollnumber','&name','&class','&malayalam','&english','&maths','&science','&total','&percenta ge','&pass_or_fail','&Malayalam_sub_pass_percentage'); Enter value for rollnumber: 91061562 Enter value for name: manikandan Enter value for class: mca Enter value for malayalam: 69 Enter value for english: 58 Enter value for maths: 58 Enter value for science: 100 Enter value for total: 0 Enter value for percentage: 0 Enter value for pass_or_fail: Enter value for malayalam_sub_pass_percentage: 0 old 1: INSERT INTO san VALUES ('&rollnumber','&name','&class','&malayalam','&english','&maths','&s new 1: INSERT INTO san VALUES ('1324567','manikandan','mca','56','85','58','59','0','0',' ','0') 1 row created. **sql> select rollnumber,name,class,malayalam,english,maths,science from san; Output: ROLLNUMBER NAME CLASS MALAYALAM ENGLISH
MATHS SCIENCE
91061562 manikandan k MCA 69 58 58 100 RESULT:**
Program No: 6 PREPARE A LIST OF ALL STUDENTS WHO ARE HAVING ARREARS Date: Aim: Algorithm: Queries:
SQL> update studentsbba2 set percentage = total/400*100; 2 rows updated. SQL> select * from STUDENTSBBA2; ROLLNUMBER NAME CLASS MALAYALAM ENGLISH
MATHS SCIENCE TOTAL PERCENTAGE PASS_OR_FAIL
123456 KEERTHANA III BBA 80 50 20 100 250 63 987456 SARANYA III BBA 90 50 60 80 280 70 SQL> update studentsbba2 set pass_or_fail='pass' where malayalam > 35 and english > 35 and maths > 3 5 and science > 35; 1 row updated. SQL> update studentsbba2 set pass_or_fail='fail' where malayalam < 35 and english < 35 and maths < 3 5 and science < 35; 1 row updated. SQL> select * from studentsbba2; ROLLNUMBER NAME CLASS MALAYALAM ENGLISH
MATHS SCIENCE TOTAL PERCENTAGE PASS_OR_FAIL
123456 KEERTHANA III BBA 80 50 20 100 250 63 fail
60 80 280 70 pass **Output: SQL>select * from studentsbba2 where PASS_OR_FAIL = 'fail'; ROLLNUMBER NAME CLASS MALAYALAM ENGLISH
MATHS SCIENCE TOTAL PERCENTAGE PASS_OR_FAIL
123456 KEERTHANA III BBA 80 50 20 100 250 63 fail RESULT: Program No: 7 FIND THE PERCENTAGE OF MARKS OF A STUDENT**
