Assignment 1 -  ER Diagram

Assignment 2 - SQL Queries- Use Create, Select, Update, Delete with operators, functions, and set operator:

a. Design and Develop SQL DDL statements which demonstrate the use of SQL objects such as Table, Index and different constraints etc.

b. Write at least 10 SQL queries on the suitable database application using SQL DML Statements.

Assignment 3 - SQL Queries- All types of Join, Sub-Query and View:

a. Write at least 10 SQL queries for suitable database application using SQL DML statements using joins and subqueries.

b. Write queries using group by and having clause.