Developement Of Database and Stored Procedures for E-Commerce System

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 applicationTable of Contents Abstract Chapter 1: Introduction .....................................................................................1 1.1 Background of research..............................................................................1 1.2 Research objectives.....................................................................................2 Chapter 2: Literature Review.............................................................................4 2.1 E-Commerce ................................................................................................4 2.2 Database and stored procedure.................................................................5 Chapter 3: Database Design and Stored Procedure..........................................9 3.1 Database design ..........................................................................................9 3.2 Basic stored procedures design................................................................17 3.3 Advance stored procedure design ...........................................................23 Chapter 4: Implementation and Experiment ..................................................25 4.1 Database implementation ........................................................................25 4.2 Stored procedure implementation ..........................................................28 4.3 Website implementation ..........................................................................30 Chapter 5: Conclusion and Further Works......................................................34 Appendix ..........................................................................................................36 Appendix a: Database SQL and Tables ...........................................................40 Appendix b: Stored procedures......................................................................50 References........................................................................................................50Maste