Database Management System Lab detailed syllabus for Computer Science & Design (CSD) for 2022-23 regulation curriculum has been taken from the Rajasthan Technical University official website and presented for the computer science & design 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 Computer Science & Design 4th Sem scheme and its subjects, do visit CSD 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 Computer Science & Design, 2022-23 regulation curriculum do visit CSD 4th Sem subject syllabuses for 2022-23 regulation.
For all Computer Science & Design results, visit Rajasthan Technical University computer science & design all semester results direct link.