INT620 - Applied E-Commerce

Outline info
Last revision date 2018-07-20 11:58:15.261
Last review date 2018-07-20 11:58:22.985

Subject Title
Applied E-Commerce

Subject Description

Students will be introduced to the skills necessary to design, code, and deploy a secure client-server cloud/web-based e-business application. They will create a database driven value-added user-centric business solution using an MVC architecture and utilizing an FSOSS XAMPP/LAMP development environment.  Students will learn to develop AJAX-ified application-based solutions to real-world business problems, that must be deployed on both stand-alone and mobile platforms.

Solutions will utilize Object Oriented Perl, Templating (Template Toolkit), jQuery, jQuery.UI, CSS and HTML5. All work in the course requires an database backend, usually MySQL (or other RDBMS) and SQLite (for mobile solutions), use of the DBI class, and Apache::Session to supply a persistence framework for application/session data. will provide a touch-optimized UI framework for mobile solution development in the course.

Credit Status
1 Credit for CTY Diploma Program.

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Use project design and management skills to design and implement an e-business solution

2. Use management and job tasking skills to participate in and manage and a small team on a project

3. Use appropriate User Centered Design to add value to business solutions

4. Design and develop client-server cloud/web-based applications appropriate to their business use in their aesthetics, usability, standard coding practices, and technical requirements and restrictions.

5. Logically separate application design elements from functional elements

6. Logically and practically separate business code from it's visualization

7. Design and use complex multi-dimensional data containers/variables suitable for use in data mining and sharing in an application utilizing the MVC paradigm

8. Design and concurrently develop mobile and desktop business solutions with reusable models and multiple platform-specific views

9. Acquire skill with a variety of langauges, libraries, and IT assets needed to develop AJAX-ified business applications

10. Determine capitalization strategies as applicable.

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on for further information regarding cheating and plagiarism policies and procedures.

All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.


Topic Outline

  • Architecture-Planning and Design that satisfies the needs of both the end-user and the business
  • Compiling programs from C/C++ source code review
  • Installing/compiling Perl classes
  • Templates and Templating
  • Perl CGI review
  • Introduction to Databases (using MySQL)
  • Design and Maintenance of simple Databases
  • Perl DBI: API's in e-business
  • SQL review
  • MySQL: databases for e-business
  • Templating Toolkit (TT2) and /or HTML::Mason; utilizing templating in e-business
  • Secure Transactions: need for and implementation
  • Use of cryptography in e-business (optional)
  • Business models
  • Customer Service
  • Marketing
  • Demographics
  • Electronic payment systems (money)
  • Security, Stability, Scalability
  • Designing for easier maintenance and enhancement/modification 

Mode of Instruction
Classroom lectures and discussions are supplemented by lab sessions with the instructor, reinforced by assigned readings and assignments between classes.  

It is the student's responsibility to save documents, articles and notes that the instructor has provided on BlackBoard or in class. Students will not be able to access BlackBoard as of the last day of the student's class.

Prescribed Texts

Reference Material
My SQL & Perl for The Web
by Paul Dubois, Addison Wesley, ISBN#978-073-5710542

Beyond Fear
by Bruce Schneier, Copernicus Books, ISBN#978-038-7026206

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online ( or at Seneca's Registrar's Offices.

Modes of Evaluation
Since this is a professional credit subject, marking standards reinforce professional practice by demanding legible, tidy work. Written materials should be well organized and grammatically correct, with proper spelling and punctuation.


  • Students must retain a duplicate of all assignments.
  • Computer assignments should be documented to the instructor's standards.
  • Assignments must be handed in on the scheduled due date. Late assignments are penalized.
  • For particulars, please obtain standards, dates, etc. from your instructor.

Absenteeism and Tests
  • Students should be aware that absenteeism will impact on their inability to achieve satisfactory grades.
  • Some of the progress tests and quizzes may not be announced in advance and details of the assignment requirements may be explained in class.
  • There is no formal provision for make-up tests to replace tests you miss.
  • If you miss a test, you must provide the reason in writing to the instructor within one week. If your reason is accepted, the weighting of that test will be added to that of the final exam. Otherwise, you will be given a zero for the test. You must submit an original doctor’s certificate identifying the date, length of time of expected absence and the specific reason for your absence, or other appropriate documentation.

Term Work and Final Exam
  • Students must attain a combined grade of at least 50% on term work and the final exam. Students must pass the final exam in order to pass the subject
  • For further information on evaluation and academic standing, see a copy of the Academic Policy available at Seneca registration offices.

Grading is based on the following marking scheme: 

Quizzes and Tests (min 2) 30%
Assignments/Presentations ( at least 2) 30%
Lab/Group 10%
Exam/Major Project 40%

Approved by: Susan Savoie