Database management System Lab 1618406 - As per SBTE Syllabus 2016 - 2017

Database management System Lab 1618406 - II Year Computer Science and Engineering as per SBTE Bihar Syllabus

DBMS LAB UNIT 01 - Hands-on experiments on any RDBMS to implement the role of Database Administrator like creating the users, alter user, grant and revoke of rights of users.

DBMS LAB UNIT 02 - Create a Database of Employees and Department.

DBMS LAB UNIT 03 - Create suitable tables to perform the following relational operations like Select, project, product, join, restriction, union, intersection, difference.

DBMS LAB UNIT 04 - Perform the following data manipulation operation - a) Insertion of record. b) Deletion of records. c) Updating records.

DBMS LAB UNIT 05 - Perform the following SQL constructs (table from experiment 3) a. Select.... From..... Where..... Group By...... Having..... Order By...... Having..... Order by

DBMS LAB UNIT 06 - Create views, Temporary tables and perform nested queries on the table created in the problem.

DBMS LAB UNIT 07 - Develop a small application using Visual Basic as front end and Oracle SQL as back end using ODBC connectivity.

DBMS LAB UNIT 08

DBMS LAB UNIT 09 - Creation, Updation, insertion and deletion of tables.

DBMS LAB UNIT 10 - Writing queries on tables, PL SQL programming, and event-driven programming.

_____________________________________________________________________________