STRUCTURE OF STORING RESPONSES OF QUESTIONNAIRES FROM MS-EXCEL INTO HDBMS

• Main Authors: Dr. Rasika Khandal, Dr. Vijay Khandal
• Format: Article in Journal/Newspaper
• Language: unknown
• Published: 2018
• Subjects: DML
• Online Access: https://zenodo.org/record/1226568; https://doi.org/10.5281/zenodo.1226568

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.