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: Database Design II (W'05)
Course Outline

Instructor: Dave Rogers

Course Description

COMP220, Database Design II, 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 I, 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


Weekly lectures present a general overview of the course material. Lectures and sample database patterns and application development techniques will usually be given during the Tuesday class.


The Thursday class will be used primarily for individual term project work.


  • COMP210: Database Design I
  • COMP118, 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 the course if more than 10% of the scheduled contact hours are missed. Dismissal from a course may result in loss of full-time status and loss of sponsorship funding.

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



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

You will plan, design, and construct a database-driven web application as your individual term project. 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 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.