Database Management System Lab detailed syllabus for Robotics Process Automation (RP) for 2021 revision curriculum has been taken from the SITTTRs official website and presented for the Robotics Process Automation 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 Robotics Process Automation 3rd Sem scheme and its subjects, do visit Robotics Process Automation (RP) 3rd Sem 2021 revision scheme. The detailed syllabus of database management system lab is as follows.
Course Objectives:
- Impart to design, develop and manage relational databases using SQL.
- Understand the design of databases with constraints for real world applications.
Course Outcomes:
On completion of the course, the student will be able to:
- Make use of DDL, DML commands to construct and manage databases
- Make use of aggregate functions, join operations, views and nested queries
- Develop SQL programming using functions, procedures, cursors and trigger
- Design and develop databases for real world applications
Module 1:
- Experiment with DDL commands-CREATE, ALTER, DROP
- Apply integrity constraints – PRIMARY KEY, NOT NULL, DEFAULT, CHECK, UNIQUE, FOREIGN KEY
- Apply DML commands – INSERT, SELECT, UPDATE and DELETE to manipulate databases
- Experiment with WHERE, DISTINCT, BETWEEN, ORDER BY, IN, LIKE, set operations in SELECT statements for data retrieval from the databases
Module 2:
- Identify aggregate functions -SUM, AVG, COUNT, MIN, MAX – GROUP BY and HAVING clause
- Develop nested queries
- Develop SQL queries for inner and outer joins.
- Construct various views of the table
Module 3:
- Experiment with stored procedures for simple tasks
- Utilize stored functions for database manipulations
- Experiment with cursors for database operations
- Develop SQL programs using triggers
Module 4:
- Open Ended Experiments
Sample Open Ended Experiments
(Not for End Semester Examination but compulsory to be included in Continuous Internal Evaluation.) Students can-do open-ended experiments as a group of 2-3. There is no duplication in experiments between groups.
Consider the following scenarios:
- Student information system
- Hostel management
- Library management
- Super market billing system
Students should gather the required information, draw the ER diagrams, map them to the relative databases and normalize the tables.
Text Books:
- Elmasri, Navathe, Database Systems ,6th ed., Pearson,2011
Reference Books:
- Sliberschatz A., H. F. Korth and S. Sudarshan, Database System Concepts, 6th ed, McGraw Hill, 2011.
- ITL Education Solutions ltd, Introduction to Database Systems, Pearson,2011
Online Resources
- https://www.w3schools.com/sql
- https://www.tutorialspoint.com/sql
- https://www.j avatpoint. com/ sql
- https://www.guru99.com/sql
For detailed syllabus of all other subjects of Robotics Process Automation (RP), 2021 revision curriculum do visit Robotics Process Automation 3rd Sem subject syllabuses for 2021 revision.
To see the syllabus of all other branches of diploma 2021 revision curriculum do visit SITTTR diploma all branches syllabus..
To see the results of Robotics Process Automation (RP) of diploma 2021 revision curriculum do visit SITTTR diploma Robotics Process Automation (RP) results..
For all Robotics Process Automation academic calendars, visit Robotics Process Automation all semesters academic calendar direct link.