Structure Of Storing Responses Of Questionnaires From Ms-Excel Into Hdbms

• Main Authors: Dr. Rasika Khandal, Dr. Vijay Khandal
• Format: Text
• Language: unknown
• Published: Zenodo 2018
• Subjects: DML
• Online Access: https://dx.doi.org/10.5281/zenodo.1226567; https://zenodo.org/record/1226567

The purpose of this paper is to identify the structure of storing responses of questionnaires from MS-Excel into the hierarchical data model. To explore the structure of responses which is stored in MS-Excel datasheet, help has been taken of a questionnaire designed by a business management researcher. The simple excel response sheet is structured into HDBMS by using the concept of hierarchical representation of data. A comparative study of structure of responses of questionnaires in MS-Excel and HDBMS data model is made. It has been found that the hierarchical database model is a better option for storing responses of questionnaires Keywords: Questionnaire, Hierarchical Database Management System (HDBMS), Virtual Parent-Child relationship, Integrity Constraints, DDL and DML for HDBMS.