|
Title:
|
END USER DATABASE MANAGEMENT: TRADE-OFFS WHEN STORING MULTI-VALUED DATA IN SPREADSHEETS |
|
Author(s):
|
Theresa Mclennan , Clare Churcher |
|
ISBN:
|
978-972-8924-30-0 |
|
Editors:
|
Nuno Guimarães and Pedro Isaías |
|
Year:
|
2007 |
|
Edition:
|
Single |
|
Keywords:
|
Spreadsheet design, multi-valued data, many-to-many relationships, end user database management. |
|
Type:
|
Full Paper |
|
First Page:
|
35 |
|
Last Page:
|
42 |
|
Language:
|
English |
|
Cover:
|
|
|
Full Contents:
|
click to dowload 
|
|
Paper Abstract:
|
Many end users still take advantage of the immediacy and simplicity of spreadsheets as a medium for storing simple data. It is not always clear which is the best way to arrange the data in a spreadsheet. We have identified a number of arrangements that can be used for storing multi-valued data. In particular we look at the ease of data entry and validation, querying the data, and producing summaries and reports for each of the arrangements. Understanding these issues will allow users to decide on the most appropriate arrangement for their multi-valued data. |
|
|
|
|
|
|
