Database Management System Lab detailed syllabus for CSE (IOT) (CSEIOT) for 2022-23 regulation curriculum has been taken from the Rajasthan Technical University official website and presented for the cse (iot) students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For CSE (IOT) 4th Sem scheme and its subjects, do visit CSEIOT 4th Sem 2022-23 regulation scheme. The detailed syllabus of database management system lab is as follows.
List of Experiments:
- Design a Database and create required tables. For e.g. Bank, College Database
- Apply the constraints like Primary Key, Foreign key, NOT NULL to the tables.
- Write a SQL statement for implementing ALTER,UPDATE and DELETE.
- Write the queries to implement the joins.
- Write the query for implementing the following functions: MAX (), MIN (), AVG () and COUNT ().
- Write the query to implement the concept of Integrity constrains.
- Write the query to create the views.
- Perform the queries for triggers.
- Perform the following operation for demonstrating the insertion , updation and deletion
- Using the referential integrity constraints.
- Write the query for creating the users and their role.
Data Base Designing Project:
For better understanding students (group of 3-4 students) should design data base for any data base project, understand the requirement and design methodology of project by its own.
Some example of data base design project like:
College management system, Inventory management system and Hospital management system.
For detailed syllabus of all other subjects of CSE (IOT), 2022-23 regulation curriculum do visit CSEIOT 4th Sem subject syllabuses for 2022-23 regulation.
For all CSE (IOT) results, visit Rajasthan Technical University cse (iot) all semester results direct link.