Open Access Open Access  Restricted Access Subscription or Fee Access

Database Design of a Software Tool for Effective Design of Online Shopping Websites

Ashish K. Sharma, Sunanda P. Khandait

Abstract


Recently there has been a considerable rise in the use of online shopping. Since online shopping involves doing transactions online, it is essential to have required structures and mechanisms of security when dealing with the data involved in the process. Since the data is very vital for the companies involved in online shopping businesses, effective management of data is highly asked for to store, manage and retrieve information with ease and élan. Databases are used for the purpose. However, designing the database is very crucial as even the good application programs cannot overcome bad database designs. Moreover, a good database design ensures ease of access and retrieval of information besides improving performance. To this end, this paper aims to design the database for a software tool for effectively design of online shopping websites. The paper considers Fuzzy Quality Function Deployment (FQFD) based software for effectively design of online shopping websites. The paper discusses the QFD and fuzzy concepts in this regard. The paper then illustrates the detailed design of database through Value chain, tables, schemas and descriptions, flowcharts and E-R diagram. Understanding the general architecture and structure of database system will help database designers effectively develop and maintain the database.

Keywords: Online Shopping, database design, websites, quality function deployment (QFD), fuzzy, software

 

Cite this Article:
Ashish K. Sharma, Sunanda P. Khandait. Database Design of a Software Tool for Effectively Design of Online Shopping Websites. Journal of Advanced Database Management & Systems. 2015; 2(1): 1–11p.


Full Text:

PDF

References


Kuo HM, Chen C. Application of quality function deployment to improve the quality of internet shopping website interface design. International Journal of Innovative Computing, Information and Control ICIC International. 2011; 7(1): 253–268p.

Kimberlee M. http://www.adweek.com/socialtimes/data-growth-e-commerce-infographic/199692, June 13, 2014.

Sharma AK, Padamwar BV. Fuzzy logic based systems in management and business applications. International Journal of Innovative Research in Engineering & Science. 2013; 1(2): 1–6p.

Deepali. Study on growth of online shopping in India. International Journal of Computer Science and Mobile Computing. 2013; 6(2): 65–68p.

Team Y. S.(2013). Google India study reports numbers about online shopping in India; ‘Electronics’ top search but ‘Apparels’ most bought. Retrieved August 24, 2014, from: http://yourstory.com/2013/01/google-india-study-about-online-shopping/.

Chen Y. et al. Rating technical attributes in fuzzy QFD by integrating fuzzy weighted average method and fuzzy expected value operator. European Journal of Operational Research. 2006; 174(3): 1553–1566p.

Lin MC. et al. Using fuzzy QFD for design of low-end digital camera. International Journal of Applied Science and Engineering. 2004; 2(3): 222–233p.

Zaim S, Sevkli M. The Methodology of quality function deployment with crisp and fuzzy approaches and application in the Turkish shampoo industry. Journal of Economic and Social Research. 2002; 4(1): 27–53p.

Badia A, Lemire D. A Call to Arms: Revisiting Database Design. SIGMOD Record. 2011; 40(3): 61–69p.

Park HS, Noh SJ. Enhancement of web design quality through the QFD approach. Total Quality Management. 2010; 13: 393–401p.

Islam R. et al. Application of quality function deployment in redesigning website: A case study on TV3. International Journal of Business Information Systems. 2007; 2(2): 195– 216p.

Jinling C. et al. Modeling e-commerce website quality with quality function deployment. IEEE International Conference on e-Business Engineering. 2009; 417– 422p.

Sauro J. Prioritizing UI improvement: The QFD (2013). (Online) Available: http://www.measuringusability.com/blog/QFD-ui.php(Accessed on August 24, 2014).

Barutchu S. Quality function deployment in effective website designs: an application in e-store design. 2006; 7(1): 41–63p. file:///C:/Users/pc18/Downloads/0deec52eb889f4ac7e000000.pdf

Ioannou G. et al. A quality function deployment approach to web-site development: applications for electronic retailing. Management Technology. 2004; 13(3): 1–18p.

Hamilton J. Integrating web site design features for one-on-one marketing: a QFD framework. In 7th International Conference on ISO 9000 and TOM (7-ICIT); 2002.

Barnes SJ Vidgen R. Measuring web site quality improvements: a case study of the forum on strategic management knowledge exchange. Industrial Management & Data Systems. 2003; 103(5): 297–309p.

Liu D. Web design using a quality function deployment methodology. University of Nebraska Lincoln. 2002.

Shad Z., Roghanian E. and Mojibian F. Integration of QFD, AHP, and LPP methods in supplier development problems under uncertainty. Journal of Industrial Engineering International. 2014.

Sundar RU. Application of quality function deployment method and fuzzy logic for improving the design characteristics in FRP cooling tower-case study. International Journal of Engineering Science and Technology. 2012; 4(7): 3059p.

Bakshi T. et al. A novel integrated AHP-QFD model for software project selection under fuzziness. International Journal of Computer Applications. 2012; 54(7): 36–43p.

Sen CG, Baracli H. Fuzzy quality function deployment based methodology for acquiring enterprise software selection. Expert Systems with Applications. 2010; 37(4): 3415–3426p.

Akao Y. Quality function deployment: integrating customer’s requirements into product design Cambridge. MA: Productivity Press; 2004.

Kahraman C., et al. An fuzzy optimization model for QFD planning process using analytic network approach. European Journal of Operational Research, Elsevier. 2004; 171(2): 390–411p.

Hauser JR, Clausing DP. The house of quality. Harvard Business Review. 1988; 66(5–6): 6–73p.

Sharma AK, Padamwar BV. Fuzzy logic based systems in management and business applications. International Journal of Innovative Research in Engineering & Science. 2013; 1(2): 1–6p.

Naieni J. et al. An approach for accident forecasting using fuzzy logic rules: a case mining of lift truck accident forecasting in one of the Iranian car manufacturers. International Journal of Industrial Engineering & Production Research. 2012; 23(1): 53–64p.

Das TK, Das Y. Design of a room temperature and humidity controller using fuzzy logic. American Journal of Engineering Research. 2013; 11(2): 86–97p.

Tomova M. et al. Fuzzy logic hysteresis control of a single-phaseon-grid inverter: computer investigation. International Journal of Power Electronics and Drive System. 2013; 3(2): 179–184p.

Balanica V. et al. Evaluation of breast cancer risk by using fuzzy logic. U.P.B. Sci. Bull. Series C. 2011; 73(1): 53–64p.

Bhosale GA, Kamath RS. Fuzzy inference system for teaching staff performance appraisal. International Journal of Computer and Information Technology. 2013; 2(3): 381–385p.

Kaur S. and Goyal R. Fuzzy logic based decision support system for poor team cohesiveness. International Journal for Science and Emerging Technologies. 2012; 2(1): 1–6p.

Tripathy MR et al. Energy efficient fuzzy logic based intelligent wireless sensor network. Progress in Electromagnetic Research Symposium, Cambridge. 2010; 91–95p.

Jurgutis and Simutis R. An investment portfolio management using software agents that rely on fuzzy logic and with different decision arguments combinations. David Publishing, Computer Technology and Application. 2012; 808–817p.

Kurnaz S, Cetin O, Kaynak O. Fuzzy logic based approach to design of flight control and navigation tasks for autonomous unmanned aerial vehicles. Journal of Intelligent and Robotic Systems. 2009; 54(1): 229–244p.

Impagliazzo J. Computing curricula 2005. ACM SIGCSE Bulletin. 2006; 38(3): 311p.


Refbacks

  • There are currently no refbacks.


This site has been shifted to https://stmcomputers.stmjournals.com/