These miniprojects were undertaken as a part of CS F212 DBMS under Professor Jayalakshmi of BITS PILANI Hyderabad.
The first project(miniproject1.sql) was to make a university management system which should contain the following:
-
Minimum 3 table creation and insertion of atleast 5 tuples in each table.
-
Query for updating the tuples values based on criteria mentioned.
-
Query to retrieve the tuples based on Group by, Order by and Having clauses.
-
Queries to retrieve the tuples based on any two joins present in SQL.
-
Queries to retrieve the tuples based on atleast two aggregate functions.
-
Subqueries to retrieve the tuples.
The second project(miniproject2.sql) was to take the tables from the previous miniproject and do the following:
-
Create a package that may either have a combination of procedure and function or only procedures/functions.
-
Atleast 2 procedures/functions should be there in the package.
-
Procedures and functions should only have DML operations (updation, insertion and deletion) along with the exceptions that handles the errors caused during the operation.
-
The DML should be done for more than one row/all rows present in the table.
-
Both before and after Triggers should be done for all DML operations
Apart from all this, we had to document all of our workings in a PDF format for both the miniprojects which had to be submitted to the instructor in charge. The people who worked on the project along with their ID numbers are:
- Shaurya Agarwal (2021AAPS2047H) (Me)
- Suchitra Sahu (2021A8PS2210H)
- Ashrita Vaka Naidu (2021A3PS3061H)
- Suchetana Mukherjee (2021AAPS0759H)
- Aasheel Dave (2021A4PS3094H)