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
.NET Programming Practical List 1. Write practical enumeration 2. Write practical message box and input box 3. Write practical string function 4. Write practical mathematics function 5. Write practical data type conversion function 6. Write practical data type checking function 7. Write practical option statements 8. Write practical Tic tac toe game. 9. Write practical calculator 10. Write practical exception handling (example structure and unstructured) 11. Write practical keyboard and mouse event 12. Write practical Library Project. 13. Write practical Notepad App. 14. Write practical Ritchtextbox 15. Write practical Groupbox and panel 16. Write practical listbox combobox, checlistkbox, 17 Write practical button three click event 18 Write practical Listview 19 Write practical Treeview 20 Write practical imagelist 21 Develops GUI application which accept for an employee of a company accept personal details, salary information using separate interactive forms store the information i
Comments
Post a Comment