CS 207Bishop's University

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.


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
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.

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:

  1. Stefan Bruda is administrator of linux.ubishops.ca
  2. 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.

Lin Jensen