Course Outline

Welcome to the course website for COMP 220: Database Design II. As the course progresses, this website will grow to include lecture notes, project descriptions and deliverables, quiz answers, grades, and links to referenced materials.

Instructor

Instructor:		Dave Rogers (View Weekly Campus Schedule)
Email Address:		not available
Office:		A2511
Office Telephone:		(867) 668-8868
Office Hours:		Tuesdays and Thursdays 3:00 pm to 4:00 pm, or by appointment.

Class Email Announcements

A mailing list has been set up for the COMP 220 class. Any message sent to this address will be redirected to every member of the class, including the instructor. If you want to add your email address (multiple addresses are fine), send a note to the instructor.

Class Schedule

Room:		A2704
Time:		Tuesday 6:00 pm to 9:00 pm, Thursday 6:00 pm to 8:00 pm

Course Description

COMP 220, 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. COMP 220 builds upon the COMP 210 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.

Prerequisites

• COMP 210: Database Design I
• COMP 101, or CPSC 114, or some programming experience
• COMP 212, or some web page design experience using HTML and JavaScript

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

Course Format

Lecture

Weekly lectures present a general overview of the course material.

Lab

The scheduled lab hours will be used primarily for individual term project work. Specific problem-solving techniques will also be introduced during the lab sessions.

Notes and Resources

All course notes, handouts, readings, and links to online resources will be posted on the course website: http://grover.yukondude.com/comp220.

Textbook

• Chris Bates, Web Programming: Building Internet Applications, Second Edition, Wiley.
• David M. Kroenke, Database Processing: Fundamentals, Design, and Implementation, Eighth Edition, Prentice Hall. This is the same text used for COMP 210.

Course Requirements

Attendance and Participation

Regular attendance and participation is essential. If you must miss class, please inform the instructor ahead of time. It is your responsibility to take notes, obtain missed assignments, and collect handouts for any class you have missed. You are expected to review topics as outlined in the course calendar prior to class.

You may be withdrawn from the course if you have missed more than 10% of the scheduled hours. Withdrawal from a course may result in loss of full-time status and loss of sponsorship funding.

Dishonesty and Plagiarism

Dishonesty, plagiarism, or cheating of any kind is a serious offense and all parties will receive a mark of 0.

Course Evaluation

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.

Quizzes

There will be 6 quizzes throughout the term. The quizzes will cover the material taught in the lecture and lab. 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.

Final Examination

The Final Exam will cover all aspects of the course.

Grading

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