Overview
Here are the assignment and exercise topics, weights, and due dates. I will be posting the exercise and assignment handouts here. All exercises and assignments will be submitted on MarkUs.
Assignments
| Exercise | Topic (tentative) | Weight | Due Date | Solution | |
|---|---|---|---|---|---|
| 1 | Handout | Relational Algebra and MySQL | 15% | Part 1. Wednesday Feb. 1, 11.59pm, Submit to MarkUs UPDATED Part 2 and 3. For 5% bonus Saturday Feb. 11, 11.59pm or Friday Feb. 17, 11.59 Submit to MarkUs You can download a dumpfile for IMDB_SMALL here. To use it type mysql -u utorid -p < IMDB_SMALL.sql |
Solution Part 1 |
| 2 | Handout a2.zip | HTML, CSS, PHP | 15% |
Part 1: Worth 50% Friday March. 10, 11.59pm, Submit to MarkUs Part 2: Worth 50% Friday March. 19, 11.59pm, Submit to MarkUs--> |
|
| 3 | New Marking Scheme for A3 Handout |
Web Application and Database | 15% | Friday March 31, 11.59pm |
FAQ - Assignment 1
Q. If the mysql portion asks for a director or actor without specifying which attributes, what should I return?
A. Return the first name, last name.