Database Development

The database will consolidate the Mineral Profits data currently stored in various Excel spreadsheets. The tables in the database should be designed so that it maintains the relationships specified in the spreadsheets. A data input interface will be developed so that Administrators of the database can easily update or add new data. At the beginning of each year, the Data of the previous year should be archived and a set of tables created for the new year. The new tables should have categories (and sub-categories) based on the data of the previous year. Regular backups of the database are a priority and should be taken into consideration when designing the system. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Sunday Apr 13, 2008 1:42:18 AM: a) Consolidation of excel data should be no problem. However, it must be noted that formulas that generally go in various cells of excel are not ingested into the database (backend). Logic might have to be set into the webpages (frontend). If you have documentation of the formula within excel sheets, it would greatly help me provide you a bid. (b) How many excel sheets do you have and how many of them are inter-related (with relationships)? (c) How would you like Administrators of the database to access the database, and what kind of database is your preference. My major work is on MSSQL, MySQL, PostgreSQL and MS Access. MySQL backend with PHP frontend works best for most small-mid level operations (d) What kind of web server and database server do you have? What languages are supported on your web server? (e) Archiving and recreation of tables is not necessary in databases since the concept of database is to store (and keep archived) the data. Old data and new data can sit in the same database tables for years and years. A single statement can extract data from the stored records. For example, hundreds of years of weather data gets stored in one database table and information of a particular hour can be pulled out in a matter of seconds from 10-million records. It all depends on how well database is designed. a) There are no calculations. Data is entered manually. b) No inter- relationships between sheets within a workbook. c) Front-end access with login access. MYSQL and php is good.I use web-hosting by [login to view URL] d)Web server is by [login to view URL] - it is a linux operated server. e) You determine the best functional way of database architecture. ## Platform MS EXCEL WEB BASED