Assignment 1: Relation Algebra & SQL
Due Date: February 9, 2018 at 11:59 PM
Instructions:
This assignments consists of 2 parts; PartA which concerns relational algebra and asks you to write the relevant statements based on the conditions given and PartB where you will replicate the data from the first worksheet within a MySQL server and write
SQl queries that relate to the given parameters and test that your queries are indeed correct. Please note that you must work in groups of 2 for this assignment.
Note: Question 2 of the assignment requires essential software outlined below. See PDF for full instructions.
Software:
MySQL Community Edition
Additionally, you will need to install a program to interact with the MySQL server such as MySQL Workbench, Sequel Pro, or another program of that
is able to interact and query MySQL servers.
Download PDF
Assignment 2: HTML & CSS
Due Date: March 12, 2018 at 11:59 PM
Instructions:
You are given the task to design a new course website for CSCB20 with one other partner without the use of external frameworks for CSS and JavaScript such as Bootstrap/Materialize and JQuery respectively. You must also create use stories and their respective
wireframe mockups prior to programming the website itself. See PDF for full instructions.
Software:
Google Chrome
Additionally a text editor to create your HTML, CSS, and JavaScript files. Examples of some text editors include Atom and Sublime Text 3. Feel free to use your favourite
text editor for this assignment
Download PDF
Assignment 3
Tentative Due Date: March 30, 2018 at 11:59 PM
Instructions:
To Be Announced (TBA)
Software:
To Be Announced (TBA)
PDF Coming Soon