Hours/Week
Course Code Course Name Category C
L T P
24CC436 Database Management Systems Laboratory PC 0 0 4 2
Pre-requisite Course(s) Co-requisite Course(s)
Structured Query Language Internet programming
Course Objectives
1 To learn and implement important commands in SQL.
2 To learn the usage of nested and joint queries.
3 To understand functions, procedures and procedural extensions of databases.
4 To understand design and implementation of typical database applications .
5 To be familiar with the use of a front end tool for GUI based application development.
Course Outcomes
Upon completion of the course, students shall have ability to
C436.1 Create databases with different types of key constraints. AP
C436.2 Construct simple and complex SQL queries using DML and DCL commands. AP
C436.3 Use advanced features such as stored procedures and triggers and incorporate in GUI based application development. AP
C425.4 Create an XML database and validate with meta-data (XML schema). AP
C425.5 Create and manipulate data using NOSQL database. AP
List of Experiments:
Data Definition Commands, Data Manipulation Commands for inserting, deleting, updating and retrieving Tables and Transaction Control
1
statements
2 Database Querying – Simple queries, Nested queries, Sub queries and Joins
3 Views, Sequences, Synonyms
4 Database Programming: Implicit and Explicit Cursors
5 Procedures and Functions
6 Triggers
7 Exception Handling
8 Database Design using ER modeling, normalization and Implementation for any application
9 Database Connectivity with Front End Tools
Case Study using real life database applications anyone from the following list
a) Inventory Management for a EMart Grocery Shop
b) Society Financial Management
10 c) Cop Friendly App)– Eseva
d) Property Management – eMall
e)Star Small and Medium Banking and Finance
11 Build Entity Model diagram. The diagram should align with the business and functional goals stated in the application.
12 Apply Normalization rules in designing the tables in scope
13 Prepared applicable views, triggers (for auditing purposes), functions for enabling enterprise grade features.
Build PL SQL / Stored Procedures for Complex Functionalities, ex EOD Batch Processing for calculating the EMI for Gold Loan for each
14
eligible Customer.
15 Ability to showcase ACID Properties with sample queries with appropriate settings
Total Hours 60
Textbooks:
1 Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Seventh Edition, McGraw Hill, 2020
2 Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, Seventh Edition, Pearson Education, 2017.
Reference Books:
1 C.J.Date, A.Kannan, S.Swamynathan, “An Introduction to Database Systems”, Eighth Edition, Pearson Education, 2006
Web References:
1 https://www.geeksforgeeks.org/dbms/
2 https://www.tpointtech.com/dbms-tutorial
Assessment Methods & Levels (based on Blooms’ Taxonomy)
Summative assessment based on Continuous and End Semester Examination
End Semester Examination
Bloom’s Level Rubric based Continuous Assessment [60 marks] (in %)
[40 marks] (in %)
Remember
Understand
Apply 100% 100%
Analyze
Evaluate
Create
COs/ P
POs O PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2
C436.1 √ √ √ √ √ √ √ √ √ √
C436.2 √ √ √ √ √ √ √ √ √ √ √
C436.3 √ √ √ √ √ √ √ √ √ √ √
C436.4 √ √ √ √ √ √ √ √ √ √ √
C436.5 √ √ √ √ √ √ √ √ √ √ √
Prepared by Approved by
