Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Suggestions on "Normalizing" a Spreadsheet USer 8)
I have a bit of a challenge at work which I sure many of you have run
into before. There is someone who has designed a web interface for the
local university but her experience is with spreadsheets. As a result,
the application produces several tables that are essentially duplicated
data that I am expected to do database things with (bringing data from
these generated tables into one of several proper relational databases I
use, for example). Multiple tables = redundant data = headaches for me.
I would like to be able to direct her to some site which gives basics of database design, in language a newbie or a spreadsheet person can understand. Especially the idea of using ONE table and developing queries to look at different aspects of the data.
Thanks very much in advance for any suggestions. 8)
-- Tim - http://www.ucs.mun.ca/~tmarshal/ ^o< /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake /^^ "Want some?" - DittoReceived on Tue Jun 10 2003 - 11:24:15 CDT
![]() |
![]() |