Dbms lab questions

Dbms lab questions

• 1.
  1 1. Create aTable as employee and the details are S.No Name Designation Branch 1 Ram Manager Chennai 2 Santhosh Supervisor Madurai 3 Hari Assistant Trichy Perform the following:  Alter the table by adding a column Salary  Alter the table by modifying the column Name  Describe the table employee  Copy the table employee as emp  Truncate the table  Delete the Second row from the table  Drop the table 2. Perform the High-Level Language Extension with Trigger(Automatic Updatation) 3. Show the Calculator application using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50) Internal Examiner Viva = /25 External Examiner 2 1. Create a Table as bank and the details are S.No Cust_Name Acc_no Balance Cus_Branch 1 Ramesh 12378 100000 Adyar 2 Sam 12367 152500 Mylapore 3 Harish 12345 250000 Anna Salai Perform the following:  Simple Select  Select with where clause  Select with comparison operator >  Select with between in the field Balance  Update the Cus_Branch in the second row as Poonamallee 2. Implement the concept of Function. 3. Show the database connectivity for the library details using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50)
• 2.
  Internal Examiner Viva= /25 External Examiner 3 1. Create a Table as book and the details are S.No B_Name Author Price Publisher 1 DBMS Seema Kedhar 250 Charulatha 2 TOC John Martin 400 Tata McGraw Hill 3 C Balagurusamy 300 Technical Perform the following:  Commit the table book  Create a save point for the table book as B  Rollback the table book after inserting 4 & 5 row  Define Grant & Revoke 2. Implement the Concept of Stored procedure. 3. Show the Calculator application using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50) Internal Examiner Viva = /25 External Examiner 4 1. Create a Table as workers and the details are S.No Name Designation Branch 1 Ram Manager Chennai 2 Santhosh Supervisor Madurai 3 Hari Assistant Trichy Perform the following:  Alter the table by adding a column Salary  Alter the table by modifying the column Name  Describe the table employee  Copy the table employee as emp  Truncate the table  Delete the Second row from the table  Drop the table 2. Implement the concept of Implicit or Explicit Cursor. 3. Show the database connectivity for the Student details using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50)
• 3.
  Internal Examiner Viva= /25 External Examiner 5 1. Create a Table as bank and the details are S.No Cust_Name Acc_no Balance Cus_Branch 1 Ramesh 12378 100000 Adyar 2 Sam 12367 152500 Mylapore 3 Harish 12345 250000 Anna Salai Perform the following:  Simple Select  Select with where clause  Select with comparison operator >  Select with between in the field Balance  Update the Cus_Branch in the second row as Poonamallee 2. Implement the concept of Embedded SQL 3. Show the Calculator application using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50) Internal Examiner Viva = /25 External Examiner 6 1. Create a Table as book and the details are S.No B_Name Author Price Publisher 1 DBMS Seema Kedhar 250 Charulatha 2 TOC John Martin 400 Tata McGraw Hill 3 C Balagurusamy 300 Technical Perform the following:  Commit the table book  Create a save point for the table book as B  Rollback the table book after inserting 4 & 5 row  Define Grant & Revoke 2. Perform the High-Level Language Extension with Trigger. 3. Show the database connectivity for the Hospital details using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50)
• 4.
  Internal Examiner Viva= /25 External Examiner 7 1. Create a Table as employee and the details are S.No Name Designation Branch 1 Ram Manager Chennai 2 Santhosh Supervisor Madurai 3 Hari Assistant Trichy Perform the following:  Alter the table by adding a column Salary  Alter the table by modifying the column Name  Describe the table employee  Copy the table employee as emp  Truncate the table  Delete the Second row from the table  Drop the table 2. Implement the concept of Function. 3. Show the Calculator application using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50) Internal Examiner Viva = /25 External Examiner 8 1. Create a Table as bank and the details are S.No Cust_Name Acc_no Balance Cus_Branch 1 Ramesh 12378 100000 Adyar 2 Sam 12367 152500 Mylapore 3 Harish 12345 250000 Anna Salai Perform the following:  Simple Select  Select with where clause  Select with comparison operator >  Select with between in the field Balance  Update the Cus_Branch in the second row as Poonamallee 2. Implement the Concept of Stored procedure. 3. Show the database connectivity for the Employee details using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50)
• 5.
  Internal Examiner Viva= /25 External Examiner 9 1. Create a Table as book and the details are S.No B_Name Author Price Publisher 1 DBMS Seema Kedhar 250 Charulatha 2 TOC John Martin 400 Tata McGraw Hill 3 C Balagurusamy 300 Technical Perform the following:  Commit the table book  Create a save point for the table book as B  Rollback the table book after inserting 4 & 5 row  Define Grant & Revoke 2. Implement the concept of Embedded SQL 3. Show the Calculator application using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50) Internal Examiner Viva = /25 External Examiner 10 1. Create a Table as workers and the details are S.No Name Designation Branch 1 Ram Manager Chennai 2 Santhosh Supervisor Madurai 3 Hari Assistant Trichy Perform the following:  Alter the table by adding a column Salary  Alter the table by modifying the column Name  Describe the table employee  Copy the table employee as emp  Truncate the table  Delete the Second row from the table  Drop the table 2. Implement the Concept of Function 3. Show the database connectivity for the library details using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50)
• 6.
  Internal Examiner Viva= /25 External Examiner 11 1. Create a Table as bank and the details are S.No Cust_Name Acc_no Balance Cus_Branch 1 Ramesh 12378 100000 Adyar 2 Sam 12367 152500 Mylapore 3 Harish 12345 250000 Anna Salai Perform the following:  Simple Select  Select with where clause  Select with comparison operator >  Select with between in the field Balance  Update the Cus_Branch in the second row as Poonamallee 2. Implement the concept of Embedded SQL. 3. Show the Calculator application using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50) Internal Examiner Viva = /25 External Examiner 12 1. Create a Table as book and the details are S.No B_Name Author Price Publisher 1 DBMS Seema Kedhar 250 Charulatha 2 TOC John Martin 400 Tata McGraw Hill 3 C Balagurusamy 300 Technical Perform the following:  Commit the table book  Create a save point for the table book as B  Rollback the table book after inserting 4 & 5 row  Define Grant & Revoke 2. Implement the concept of Function. 3. Show the database connectivity for the Customer details using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50)
• 7.
  Internal Examiner Viva= /25 External Examiner 13 1. Create a Table a bank and the details are S.No Cust_Name Acc_no Balance Cus_Branch 1 Ramesh 12378 100000 Adyar 2 Sam 12367 152500 Mylapore 3 Harish 12345 250000 Anna Salai Perform the following:  Simple Select  Select with where clause  Select with comparison operator >  Select with between in the field Balance  Update the Cus_Branch in the second row as Poonamallee 2. Implement the concept of Implicit Cursor or Explicit Cursor 3. Show the Calculator application using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50) Internal Examiner Viva = /25 External Examiner 14 1. Create a Table as workers and the details are S.No Name Designation Branch 1 Ram Manager Chennai 2 Santhosh Supervisor Madurai 3 Hari Assistant Trichy Perform the following:  Alter the table by adding a column Salary  Alter the table by modifying the column Name  Describe the table employee  Copy the table employee as emp  Truncate the table  Delete the Second row from the table  Drop the table 2. Implement the concept of Stored Procedure(Any one).
• 8.
  3. Show thedatabase connectivity for the Student details using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50) Internal Examiner Viva = /25 External Examiner 15 1. Create a Table as book and the details are S.No B_Name Author Price Publisher 1 DBMS Seema Kedhar 250 Charulatha 2 TOC John Martin 400 Tata McGraw Hill 3 C Balagurusamy 300 Technical Perform the following:  Commit the table book  Create a save point for the table book as B  Rollback the table book after inserting 4 & 5 row  Define Grant & Revoke 2. Implement the concept of Embedded SQL 3. Show the Calculator application using VB. Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50) Internal Examiner Viva = /25 External Examiner 16 1. Create a Table a bank and the details are S.No Cust_Name Acc_no Balance Cus_Branch 1 Ramesh 12378 100000 Adyar 2 Sam 12367 152500 Mylapore 3 Harish 12345 250000 Anna Salai Perform the following:  Simple Select  Select with where clause  Select with comparison operator >  Select with between in the field Balance  Update the Cus_Branch in the second row as Poonamallee 2. Implement the concept of Implicit Cursor or Explicit Cursor 3. Show the database connectivity for the library details using VB.
• 9.
  Aim and Description (10) Query (15) Result (5) Output (5) Record (15) Total (50) Internal ExaminerViva = /25 External Examiner SAVEETHA SCHOOL OF ENGINEERING Saveetha UNIVERSITY CHENNAI – 602 105 UNIVERSITY PRACTICAL EXAMINATION SUB CODE: CS 3413 SUB NAME : Database Management Systems DATE : 05.05.14 SESSION : FN / AN YEAR/BRANCH: II Year CSE A LIST OF EXPERIMENTS 1. Data Definition Language (DDL) commands in RDBMS. • Creating a table • Deleting a table • Altering the contents of the table • Truncating a table • To view table structure • Dropping a table 2. Data Manipulation Language (DML) and Data Control Language (DCL) commands in RDBMS. • DML Commands: o Insertion of information o Retrieval of information o Deleting information o Modifying information • DCL Commands: o Grant Privilege o Revoke Privilege 3. High-level language extension with Cursors. 4. Cursor Command: • Open
• 10.
  • Fetch • Close 5.High level language extension with Triggers 6. Procedures and Functions 7. Embedded SQL 8. Design and implementation of Payroll Processing System. 9. Design and implementation of Banking System. 10. Design and implementation of Library Information System. INTERNAL EXAMINER EXTERNAL EXAMINER