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 -- -- -- "Problems are solved by method" _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
