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

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 research...

Full description

Bibliographic Details
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
Description
Summary: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.