Database Management System Lab detailed syllabus for Information Technology (IT) for 2021-22 regulation curriculum has been taken from the Rajasthan Technical University official website and presented for the information technology 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 Information Technology 4th Sem scheme and its subjects, do visit IT 4th Sem 2021-22 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 Information Technology, 2021-22 regulation curriculum do visit IT 4th Sem subject syllabuses for 2021-22 regulation.
For all Information Technology results, visit Rajasthan Technical University information technology all semester results direct link.