Assignment List 

1. Assignment 1: Install and configure client and server for MySQL and MongoDB

2. Assignment 2: Design any database with at least 3 entities and relationships between them. Draw suitable ER/EER diagram

3. Assignment 3: Create Table with primary key and foreign key constraints for assignment no 2 and apply DCL, DDL and DML 

a. DDL Commands

b. DML Commands

c. DCL Commands

• Transactions - Grant/Revoke Users

d. Add Constraints

e. Foreign Key

         f. Aggregate Functions

         g. Group by

         h. Having

          i. group by + having 

4. Assignment 4: Write and execute suitable database triggers and Joins

• Triggers

• Joins

  • • Left JOIN

    • Right JOIN

    • Inner JOIN

    • Outer JOIN

5. Assignment 5: Execute DDL/DML statements which demonstrate the use of views, cursor.

• Cursor1

• Views

6. Assignment 6: Create a database with suitable example using MongoDB

• Solution 1

7. Assignment 7: MongoDB 

• find and findOne, Query criteria, 

• Cursors (Limits, skips, sorts, advanced query options) 

• Exercises 

8. Assignment 8: Develop a mini project using the database identified in Assignment no. 2.