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.