CS 207

Database & Dynamic Web Design

Course Outline

Class meets

Prof. Lin Jensen
Website https://cs.ubishops.ca/ljensen
e-Mail: - please keep messages short

Course website: http://cs.ubishops.ca/ljensen/webdesign

Textbook: the course pack for for CS 203 is still relevant, and it is also on line. There are dozens of Database books in the library.

This course builds upon CS 203, and adds to that the use of a database for flexible storage and retrieval of data.

Therefore, I can assume (only) that your previous experience includes familiarity with HTML, CSS, PHP and JavaScript. You will learn an additional "language", SQL, and how to use it to create and maintain a database. The SQL servers running on Osiris are PostgreSQL (and also MySQL). I will present PostgreSQL in the lectures.

This is a "hands-on" course. You will be expected to do lab work each week, and complete some programming projects as we go along. These need to be done in a timely fashion, as they will build one upon the other. An overall goal of the course is to create your own "home pages" that you will be proud of.

Topics:

Review of HTML, CSS, PHP and JavaScript

Forms (information sent from client to server)

Accessing a database on the server (using PHP and SQL)
Concerns about security and abuse. - SQL injection, cross-site scripting, content "spam"
translation (gettext)
other advanced topics, as they may appear

I expect you to participate in the weekly labs. Please note that you will get a single mark for the course including the lab, even though the lab is registered separately as a matter of administrative convenience.

Grading Scheme

Programming assignments (lab)	60%
Content of final pages	10%
Midterm - date TBA	10%
Final exam	20%

You must pass the exam portion to pass the course. No supplemental exam will be allowed.
Please note that you will get a single mark for the course including the lab, even though the lab is registered separately as a matter of convenience.

Exams during the pandemic

For the final exam, Academic Scheduling will assign a 24 hour period. Thus, all time zones are equal. You must start and complete your exam within a fixed time interval. For the Final, I figure for a normal 3 hour exam I should allow 4 hours.
For the midterm, I will again use a 24 hour period, and choose an appropriate length for completion.

I will not use any "Proctoring software" in any exams

They raise ethical issues, and increase stress levels.

Course sign-in & Assignments:

If you took CS 203, you will have an account on Osiris. I will still need to make you a PostgreSQL database user.
Please go to any computer, and sign in to my course(s). http://cs.ubishops.ca/ljensen/signin.html
I will then believe you are actually in the course.
Likewise, I will not know if you drop the class unless you inform me with the change form: http://cs.ubishops.ca/ljensen/updateemail.html
You are responsible for actually enroling, adding, or dropping the course, this is outside of my control.

I will use this information to communicate with you. During the course, I may explain how I will be using a database to keep track of your assignments.

A Web server for this course is running on Osiris. Once the class is over, your materials may disappear. Should you wish to continue use of your Osiris account, tell me before the end of the course, and every May thereafter (by email.)

Computers in the Computer Science Lab (J-118) are administered by ITS, same as other labs on campus. They can run either Windows or Mac-OS.

For a Linux environment, we provide a virtual desktop from linux.ubishops.ca, that can be accessed by X2GOClient from either operating system, or "any Mac on campus." This is not needed fro web design, but if you want an account I will create it

You either already have an account on Osiris, or I will set one up. Your account code will normally be the first letter of your given name plus your family name -- like your ubishops account code without the trailing numbers.

Should you forget your password:

Stefan Bruda is administrator of linux.ubishops.ca
I am administrator of osiris.ubishops.ca

I expect you to be present in class and participate in the weekly labs.

What does this mean during the pandemic? You are more on your own to do lab work, and may need to install some software on your own computer. Try to attend the weekly virtual meeting, where you can ask questions and get help with lab work. For those who cannot, I will attempt to record some of the proceedings. I can also open up the meeting for individuals (ask by email) and I will try to schecule some office hours.

Lab work should be completed by Friday. Normally the assignment contains a form you will fill out to indicate you have finished, ready for marking. When I mark a lab, you will receive feedback by email, and can also view all your remarks and my feedback from a link on the course web page.

2 delays allowed

Anyone can get sick, have conflicting family commitments, or unexpected emergencies. Therefore, at most 2 lab assignments may be submitted up to two weeks late. This "grace" allowance is intended to cover unexpected contingencies, and should not be used frivolously early in the semester.

You must notify me if this is the case.
The grace assignments will not be marked promptly. You may not get them back until the end of the semester.
Once you have used up your 2 grace submissions, further late assignments will not be marked, and you will get no credit.

Back to Lin Jensen's home page.
see Lin Jensen's advanced stuff on Osiris
Visit Bishop's Computer Science website .

Lin Jensen