| Week | Information Assignments due in one week and programs in two weeks unless otherwise stated |
|---|---|
| Week #1 Assignments Week of September 2nd |
Read chapter #1 and #2 in the text Database Driven Web Sites. See me about
a copy of the text. Let me know how well you know Access. |
| Week #2 Assignments Week of September 9th |
Read chapter #3 in the text Database Driven Web Sites. Develop an Access Database following the guidelines in the Oracle oil delivery assignment. See me about borrowing another book that I think you will find helpful - it is a quick read that you can start now and finish... |
| Week #3 Assignments Week of September 16th |
Please skim through chapter #4 (you know most of it) and read chapter #5 in the
text Database Driven Web Sites. I find that I learned this material best by trying to do much of what they did with modifications that meant I was not just copying. Set up the Personal Web Server for your own use and experiment with it following the examples in the book. Send me a write up of your progress including successes, failures, attempts etc. Overview of what you did to learn the material in chapter #5! Hopefully you have acquired the CGI/Perl text by Diane Zak (ISBN 0-619-03440-8). We will start using it shortly! |
| Week #4 Assignments Week of September 23rd |
Download a free copy of Perl that you can use and find some good Perl tutorials.
Start looking at a how to work with Perl. |
| Week #5 Assignments Week of September 30th |
Read the section intitled Read This Before You Begin and chapters #1 and #2 in the
CGI/Perl book by Zak. Experiment with writing script. Look at the PowerPoint presentations on introduction to CGI/Perl and sending data. Also look at the samples (they are zipped). Assignment to pass in: Do Project 3 in Chapter #1 and Case Project #2 in chapter #2. |
| Week #6 Assignments Week of October 7th |
Read chapter #3 in the Zak book. Start playing and testing your programs with the site that was set up. See Sil about getting a password on the cis server so you can test there as well. Pick one of the projects that interests you at the back of chapter #3. Hopefully pgrocer.us will be established soon. In the meantime, you can write and check syntax. If you send something to me I will upload it to my site so you can see how it works. |
| Week #7 Assignments Week of October 14th |
Read chapter #4 in the Zak book. Start playing and testing your programs with
the site that is hopefully going to happen - or you can talk to Sil about using
the BCC site - he has a cgi-bin on it! Pick one of the projects (harder ones) to try. |
| Week #8 Assignments Week of October 21st |
Move on to chapter #5. We need to use the BCC server for an assignment in this chapter. |
| Week #9 Assignments Week of October 28th |
Move on and read chapter #6. You need to pick a project in chapter #5 and another project in chapter #6 to do. Pick ones that interest you from the back of the chapters. We need to check with Sil on the BCC server for input and output. The rest can be done through www.pgrocer.us. |
| Week #10 Assignments Week of November 4th |
Read chapter #7 and pick a project from the back of the chapter to do. I sent you the working input/output on the BCC server and I suggest you move on to using the BCC server that Sil has set up for any projects that do not work well on pgrocer.us. See Sil if you have any questions - he is definately willing to work on this with you. |
| Week #11 Assignments Week of November 11th |
Read chapter #8 and pick a project from the back of the chapter to do. Go to the site for MySQL: MySQL home page Download MySQL and play with it. Create a database and some tables. Query the database using SQL. Report on your success. The reference manual which includes tutorial information is at: MySQL Reference Manual Also see the presentation on MySQL. |
| Week #12 Assignments Week of November 18th |
Read chapter #9 and pick a project from the back of the chapter to do. This chapter is about creating a very basic database through Perl. Next we will look at a database created through MySQL. It is up and running on the site and I have sent you the information to log in. You can use MySQL to create a database and tables. |
| Week #13 Assignments Week of November 25th |
Read chapter #10 in the text. No assignment from the text this week because
I want you to play with creating a database using MySQL on the web server,
populating tables and querying tables using SQL. See the slide presentation
on this topic. Assignment: Create a database with at least three tables that can be related to each other, set up primary keys, populate the table and do some queries to show that everything is working. |
| Week #14 Assignments Week of December 2nd |
Finish reading the text. Assignment: The final project is to make a user form that takes in information from the user, returns information from the database you developed last week and updates the database. Since you are taking an incomplete, we will work on this week and last week over break. |