You must work in groups of exactly 2 (including yourself) for this assignment. Working alone is not anoption. There are two parts to this assignment. InPartAyou will write relational algebra only. InPartByou will write actual SQL queries. Note: In PartB we are also asking you to recreate the data that wasprovided in lecture worksheet1, as a SQL database. On this SQL database you will test your SQL queriesfor correctness. We will learn in lecture on 21st and 28th January on how to recreate this datamanuallyand later by writing ascript

In this assignment, you will develop a new course website for the course CSC B20 using HTML and CSS. You are notallowed to use any web framework such as BootStrap and JQuery etc. You must work in groups of two. We did makesome exceptions for Assignment1, and however, for this assignment, we ask you to form teams of 2. The webpagemust be usable, responsive, and visually appealing. Below is an example course page, however it is up to you tocreate a design following the mandates listed in this assignment. I want you to have some fun with this assignment.There are some minimum requirements, but for the most part, there is a lot of creativity!