CS 338: Computer Applications in Business: Databases

The two session will be at:

Sunday, Dec 9th @ 1 pm (MC 2034)
and
Monday, Dec 10th @ 4 pm (MC 2034)

As mentioned, these will just be open office hours and me answering questions from a group of students instead of a single student. I won't be giving ANY hints about the final exam. If you can't make it, you aren't missing anything except hearing some questions and answers (mostly me presenting material a second time). I'll plan to be there for about 1 hour each day.

Feel free to come to my office hours on Tuesday (or any of the TAs' office hours) if you want to ask questions individually. Posting questions here on piazza is another option as well.
#final #review

Tomorrow's revision will take the form of a quick overview of what the final will look like, followed by me reviewing any material you would like explained a second time. I'll expect students to come with questions like "could you please explain the second and third normal forms again". I'm happy to answer general questions about the material as well.

I *WON'T* be working through solutions to example problems, as Piazza is a better forum for this. If you would like to see a particular question solved, please post it here.

I will be posting the final exam overview that I present in class on Piazza and there won't be any hints about the material beyond this. If you aren't interested in hearing course material explained again, don't feel obligated to come.

We will be maintaining our standard office hour schedule right up until the exam. Please feel free to come to my office hours or any of the TAs' office hours with questions.
#final

The assignment says to read an article and "write a 1500 word (approximately 3 pages double-spaced) reaction to it."

I had intended a length of approximately 3 pages double spaced which, as a student has pointed out on Piazza, is actually 750 words not 1500.

If you have already planned (or written) your submission and it's 1500 words, that's fine. If you're still working on it, consider 750 words a rough minimum (and 1500 words a rough maximum). The TAs will appreciate it if you're closer to the minimum than the maximum.
#assignment4

The teaching staff has posted a new homework resource.

Title: Assignment 3
https://www.student.cs.uwaterloo.ca/~cs338/A3-f12.pdf

Due date: 11/16/2012

You can view it on the course page: https://piazza.com/uwaterloo.ca/fall2012/cs338/resources

#class-resources #homework
#assignment3

https://odyssey.uwaterloo.ca/teaching/schedule

The information about your seating will show the Exam (e.g. CS 338 Midterm), the date and Start Time (e.g. 2010-06-21 19:00:00), the building and Room (e.g. MC 2017) and the Seat (e.g. 4B). Please check all carefully. The Seat code indicates the row number and column letter, beginning in the front left corner of the front of the room - for example, 4B would be the fourth row from the front of the room and the second seat from the left when facing the front of the room.

Before you sit down at the exam, check the name and ID that will already be stamped on the exam - if it is not yours, look up your room and seat again (lists will be posted in the room) or see the proctor.
#midterm

The teaching staff has posted a new homework resource.

Title: Assignment 2
https://www.student.cs.uwaterloo.ca/~cs338/A2-f12.pdf

Due date: 10/26/2012

You can view it on the course page: https://piazza.com/uwaterloo.ca/fall2012/cs338/resources

#class-resources #homework #assignment2 #db2

It looks there are is confusion about 'how to create a file' for A1. I stress that all details are presented in the "db2 hints" and "db2 demo" and Assignment 1 itself.
To create a file in linux, after you connected to 'linux.student.cs.uwaterloo.ca', simply write down 'pico'. This is an editor in which you can write your code (you cannot copy or paste there).
After you finished writing, hit "ctrl+x" to exit. It asks you to save the file, in case you press 'y' you can select the name of a new file and hence create a file like "a.txt". The same procedure applies when you want to edit "a.txt". You just need to write 'pico a.txt' and it opens (well, in some sense) the file.

We recommend you make the files on the server and edit them there (as described above). But it looks many of you have prepared the files in your pc (with Winodws on them). In that case, you should copy the files from you system to the linux server. To do so, you should use ssh copy "scp" as follows:
1- make sure putty is installed on your system
2- open a terminal (press start button and write down 'cmd' and press enter)
3- using 'cd' command locate the folder which includes the file 'x.txt' (the file you want to copy)
4- write down the following (replace 's3kamali' with your username)
scp x.txt s3kamali@linux.student.uwaterloo.ca:~/
5- enter your student account's password to complete copy
6- the file 'x.txt' is copied into your root directory. In step 4, at the end you can specify exact location after '~/'


#assignment1 #shell

For all those who have purchased the web clicker software but can't find me on the list of instructors, the iClicker people are working on this and it should hopefully be on the list by Tuesday's class. Please let me know if it's not work then.

Thanks!

John
#clickers