LAB ASSIGNMENT -2 DBMS FYBCA (SEM 2)
LAB ASSIGNMENT -2 DBMS FYBCA (SEM 2) Create following tables solved queries Student(roll_no,name,gender,address,class) Marks(roll_no,sub1,sub2,sub3,total,percentage) 1. insert 10 records for each tables 2. add the column email_id in student table 3. list out detail of student 4. list out student detail whose percentage is 70 5. list out student detail whose class is SYBCA 6. add colomn phone no in student 7. list out student detail whose total is 300 8. list out student detail whose name is raj 9. display student of „fybca‟ 10.display marks of student whose roll_no is 25. 11. change student name raj instead of rahul. 12.change field name address instead of stud_add in student table. 13.list out student detail whose class is fybca 14.remove the records of marks table 15.destroy the detail of student. Q2 Create following tables with appropriate constrain billmaster(billno, custno, billdate, billamt, discount) customer(custno, name, custadd) 1. insert at least 10 records for each tables
Comments
Post a Comment