This course is closed. The accuracy of this page's content is not guaranteed. [Return to]

You really should consider upgrading your browser to a more recent version. You'll still be able to view everything on this site, but it'll be an ugly experience.

COMP220: Web Application Development (W'07)
Course Outline

Instructor: Dave Rogers

Course Website:

Course Description

COMP220, Web Application Development, teaches you the planning, design, and construction of web-based applications, capitalizing upon your background in relational database theory, programming techniques, and web page design. COMP220 builds upon the COMP210 course, Database Design, by introducing real-world implementations of relational data patterns, as well as the more complex syntactical forms of SQL's Data Manipulation Language. You will learn much of the material by developing a full-fledged web application as your term project.

Learning Outcomes

Upon successful completion of the course, you will learn:

  • Common relational database design patterns and efficiency techniques,
  • Multi-tiered web application design and development,
  • Concepts of stateless/transactional programming and session management,
  • Accepted principles for securing online applications,
  • Comfort and familiarity with the PHP/MySQL web application platform, and
  • An overview of software development project management.

Delivery Methods/Format

Classes will be lecture-labs. That is, each session will be held in a lab and consist of both the formal presentation of material by the instructor, and practical hands-on activities by the students. Sessions are designed so that students are able to follow examples during the mini-lectures, undertake additional examples and ask questions during the lab activities, and develop and hone their skills by completing the assignment exercises. Students will be expected to take notes during classes to study from and to use in completing the course assignments.

Weekly lab-only sessions will be devoted to project work.

Class time alone will not be enough to learn the material. To develop the necessary skills you should plan on spending between one and three hours in preparation, study and practice outside class for every hour of direct instruction, i.e. 3 to 9 hours per week.


  • COMP210, or some relational database design and SQL experience
  • COMP118, CPSC128, or some programming experience
  • COMP212, or some web page design experience using HTML and JavaScript

Admission to the course may also be granted at the instructor's discretion.


Attendance and Participation

Attendance is mandatory. A student may be dismissed from a course if more than ten percent (10%) of the scheduled contact hours are missed in any one course (Yukon College Academic Regulations, §4.01). Dismissal from a course may result in loss of full-time status and loss of sponsorship funding.

Missing a quiz or examination (either by absence or arriving too late to write) will normally mean forfeiture of the mark. An opportunity to write a missed quiz will be granted only for documented medical illness or similar emergency. Vacation scheduling is not an acceptable excuse for missing or re-scheduling a quiz or examination.

In the interest of minimizing distractions during class, students are asked not to perform the following activities during a scheduled class:

  • Sending or receiving e-mail
  • Surfing the Internet
  • Downloading or transferring files from the Internet
  • Playing computer games

There are instances where your instructor may ask you to do the above during class, in which case these activities would be acceptable. Students will be given a verbal warning the first time they are caught doing the above. The second time, a written warning will be given. A third offence will result in being compelled to leave the class.

Dishonesty and Plagiarism

The assignments are individual assignments and group submissions are not permitted. All submissions should be original work prepared for that specific assignment. To copy another person's work without permission and attribution, or present it as your own, will result in penalties. Note that plagiarism is defined not only as submitting someone else's work as yours, but also includes submitting the same assignment for more than one course without the explicit permission of the instructor. The penalties for plagiarism include receiving a mark of 0 for the assignment, a mark of F for the course and expulsion from the College.

Due to the nature of the COMP220 term project, students are encouraged to use ideas and programming code from other sources, including their fellow students. Code from another student may only be used with that student's permission. Code from other sources may be used without permission provided the code's licence permits such use. In all cases, code not written originally by the student must be indicated in some fashion, and the original authors must be properly attributed.



Five quizzes will be held on specific dates throughout the term, covering the material taught in the lectures. The one quiz with the lowest mark will be discarded from the term evaluation. Quizzes may not be rescheduled, except in exceptional circumstances and only where prior arrangements have been made with the instructor.

Term Project

Students will plan, design, and construct a database-driven web application. The project will be graded as a series of deliverables, or assignments, to be submitted on specified dates. Late deliverables will be penalized 20% per working day, unless prior arrangements have been made with the instructor.

Final Examination

The Final Exam will cover all aspects of the course.


Component Weight
Quizzes (best 4 of 5) 20%
Term Project 60%
Final Examination 20%
Total 100%

Letter grading will follow the College's standard, which can be found in the Letter Grading section of the Academic Regulations in the College Calendar.

Required Textbooks/Materials

Web Database Applications with PHP and MySQL "Web Database Applications with PHP and MySQL, 2nd Edition" (Hugh E. Williams & David Lane, O'Reilly). This book is available in the bookstore. The first edition of the text is also acceptable.