전자상거래 시스템을 위한 데이터베이스 및 저장프로시저 개발

Abstract

E-commerce has been an important entity in our daily life. Mobile commerce will make up to 45% of total revenue of e-commerce transaction by 2020. Database design is important in creating e-commerce application. Previous work on the database design for e-commerce application is improved. This thesis further improve previous work on database design for ecommerce application. The method of using stored procedure technique in creating an e-commerce application is also applied. We propose two design that is applied for e-commerce application, which is the database design and the stored procedure technique. The first proposes an improve design on e-commerce application database. We introduce a simple design that is applied and used in e-commerce application, further improving the previous design. The design focus on a simple approach to a database for e-commerce application. The second proposes on using the stored procedure technique in creating the database. Stored procedure used as a middleware for the application and the database. The stored procedure is categorised in two, which is the basic and advance stored procedure techniques. We explained on applying stored procedure technique on an e-commerce application. The proposed stored procedure and database can applied to the creation of an e-commerce application