Hi James, I don't know if you received the help you were looking for, if not contact me directly at [EMAIL PROTECTED] Have a super one! Merv
James Mills wrote: > HI folks, > > I'm seeking some assistance in analyzing > a rather flat database (imported from Excel / CSV). > I recognize the need for a more structured > database, but can't get my head around > a "good"/"best fit" set of schemas to > represent the data requried. > > If someone is willing to donate their time > in helping me here, I would greatly > appreciate it. > > Please download and see http://shortcircuit.net.au/~prologic/vv2.sql.gz > > $ gunzip vv2.sql > $ sqlite3 vv.db < vv2.sql > > There are 3 tables: > > data - The (flat) database of data. > srates - Expected export (to be CSV) of Supplier Rates > crates - Expected export (to be CSV) of Customer Rates > > The srates and crates tables are just there > for analysis purposes. These are actually > suppose to be exported CSV files called: > * SupplierRates-YYYY-MM-DD.csv > * CustomerRates-YYYY-MM-DD.csv > as at the time of the export. > > I recognize that I may need to store tables > for: > * rates > * suppliers > * customers > * dialcodes > * destinations > > But, I am not even sure if the aboave > listed tables is suitable, nor can I get my > head around the necessary schemas > required. > > I lack good "data analysis skills" :/ > > Thanks in advance to anyone that may > be willing to help. > > Thanks and > > cheers > James > > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
