Guidelines This homework is part of your term project. In this deliverable you will submit an DB schema and SQL statements. You need to submit this homework on 30 th December at 10pm, on LMS. Late submissions are not allowed, your work will not be accepted once the submission is closed on LMS. - You need to do this project in a group of up to 4 members. - Clearly report group member names and IDs in the document you submit. - Yon will submit this deliverable to LMS (only one member of the group will submit). - It is better to submit incomplete assignment than none at all. - It is strongly advised that you start working on the assignment the day you get it. - The homework should be one pdf/word file containing all of your work. - DO NOT send your assignment to your instructor over email. It won't be considered for evaluation. - You can be called in for Viva for any assignment that you submit. - This homework is 10% of overall grade. 1 DB Schema and SQL In HW1 you designed a sample database of an organization of your choice. Now you will be extending your work to implement it on MS SQL Server. The First step is to define DB schema in the server. You can do it either using graphical interface or by writing SQL statements. Your initial design in HW1 might be too large, however in this homework you can reduce the number of entities, but it should not be reduced to less than 5. You can also reduce attributes of the entities to make your database of decent size. Choose the entities in a way that each entity have a relationship with at least one more entity type. The Second step is to come up with some SQL queries to manipulate the data. You are required to write your own questions according to your own DB and answer the questions by writing the at least 1SQL statement for each of the following objects/statements. - WHERE clause - Aggregate functions (AVG, COUNT, SUM) - order by - order BY, GROUP BY - EXISTS/NOT EXISTS - Regular expressions using LIKE - BETWEEN - Set Operations (Union/Except/Intersect) - SOME, ALL Clause - CASE-WHEN clause - Subquery