DEVELOPING AN E-COMMERCE DATABASE WEB APPLICATION FOR UNIVERSITY SPORT CONCESSION EVENT: A TEACHING CASE

Abstract

This case study is developed to teach students the basics of developing a database web application. The background of the case is that a university wants to extend its sport concession event sale operation online. An e-commerce database web application is needed to capture online customer order, calculate Subtotal, Tax, and Total, and store order data into a database for future analysis. Students are asked to construct a MySQL database and a table to hold customer order data. Students also need to create a web page to take customer order. Moreover, students need to build a PHP application program to process the customer order, store data in the database, and display the new online order as well as all orders in the database table. The case study gives students a hands-on opportunity to develop a functional database web application using a popular platform – PHP and MySQL.