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

Lecture

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.

Lab

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

Prerequisites

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

Requirements

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.

Evaluation

Quizzes

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.

Evaluation

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, 2^nd Edition" (Hugh E. Williams & David Lane, O'Reilly). This book is available in the bookstore. The first edition of the text is also acceptable.