Database Management system lab (2018406) As per SBTE Syllabus

Database Management system lab (2018406) As per SBTE Syllabus 1. Know installat…

Explain for loop in PL/SQL with example.

{{**Note: Any other relevant example shall be considered. **}} For Loop :   Th…

Explain group by, order by clause of SQL with example.

Group by:  The GROUP BY STATEMENT is used with aggregate functions (MAX, MIN, S…

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

Database management System Lab 1618406 - II Year Computer Science and Engineeri…

Unit 10 - Writing queries on tables, PL-SQL programming and event driven programming.

Unit 9 - Creation, Updation, insertion and deletion of tables

Unit 8 - Creation and modification of databases through ER diagram, normalization.

Unit 7 - Develop a small application using Visual basic as front end and oracle SQL as back-end using ODBC connectivity.

Unit 6 - Create views, temporary tables and perform nested queries on the table created in problem 2.

Unit 5 - Perform the following SQL constructs (table from experiment – 3) a. SELECT..... FROM...... WHERE...... GROUP BY...... HAVING....... ORDER BY............

Unit 4 - Perform the following data manipulation operation. a. Insertion of record b. Deletion of records c. Updating records

Unit 3 Create suitable tables to perform the following relational operations. - Select, project, product, join, restriction, union, intersection, difference.

Unit 2 - Create a Database of employees and department

Unit 1 - 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 user.

Create a Database of employees and departments with the following details.- DBMS LAB UNIT