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...
| Main Authors: | , |
|---|---|
| Format: | Article in Journal/Newspaper |
| Language: | unknown |
| Published: |
2018
|
| Subjects: | |
| Online Access: | https://zenodo.org/record/1226568 https://doi.org/10.5281/zenodo.1226568 |
| 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. |
|---|