Mapping of COs with PSOs and POs: Page 65 of 241 single and multiple tables 15 Nested queries (correlated and non-correlated), Aggregation and grouping, Views, assertions, Triggers, SQL data types. 16 Introduction to NoSQL Databases 2 17 Main characteristics of Key-value DB (examples from: Redis), Document DB (examples from: MongoDB) 2 IV Transaction Processing, Concurrency Control 10 15 18 Transaction Processing: Introduction, Transaction and System Concepts 3 19 Desirable Properties of Transactions 1 20 Characterizing Schedules Based on Recoverability & Serializability 2 21 Transaction Support in SQL. 1 22 Introduction to Concurrency Control:
Two-Phase Locking Techniques 3 V DBMS LAB 30 1 Students should decide on a case study and formulate the problem 3 statement. 2 Based on Identified problem Statement, Design ER Diagram 3 (Identifying entities, attributes, keys and relationships between entities, cardinalities, generalization, specialization etc.) Note: Student is required to submit a document by drawing ER Diagram to the Lab teacher. 3 Converting ER Model to Relational Model (Represent entities and 2 relationships in Tabular form, Represent attributes as columns, identifying keys) Note: Student is required to submit a document showing the database tables created from ER Model.
4 Normalization -To remove the redundancies and anomalies in the 3 above relational tables, Normalize up to Third Normal Form 5 Creation of Tables using SQL- Overview of using SQL tool, Data 3 types in SQL, Creating Tables (along with Primary and Foreign keys), Altering Tables and Dropping Tables 6 Practicing DML commands-Insert, Select, Update, Delete 2 7 Experiment 7: Practicing Queries using ANY, ALL, IN, EXISTS, 2 NOT EXISTS, UNION, INTERSECT, CONSTRAINTS etc. 8 Practicing Sub queries (Nested, Correlated) and Joins (Inner, 2 Outer and Equi). 9 Practice Queries using COUNT, SUM, AVG, MAX, MIN, 4 GROUP BY, HAVING, VIEWS Creation and Dropping.
10 Install and Configure MongoDB to execute NoSQL Commands. 6 PSO1 PSO2 PSO3 PSO4 PSO5 PSO6 PO1 PO2 PO3 PO4 PO5 PO6 CO 1 3 2 - - - -