Devam Ediyor

488908 Add tables to MySQL database

Please take a look at I need 4 things done to this website. Part A: I have 10 new tables that need to be added to this mysql database. These 10 new tables are between 10,000 and 250,000 records and in either mdb (microsoft access) or excel format. Part B: These tables will have to be associated in mysql by zip code or county through a master zip code table and queries will have to be written to retrieve data by zip code and their output part of the report. Table indexing will be necessary to maintain speed of searches. Part C: I also need to make some minor changes to the format of the report and the main screen and add some fields to the report. One new field will be a calculated field (summation of snowfall accumulation over multiple days). Part D: I will also need a procedure for all tables in [url removed, login to view] to be updatable through 1) a bulk update (replace the tables without resulting in duplicate records, missing table associations, etc.) and 2) an individual record update (search to find a particular record, retrieve it, edit or delete) I also need to add individual records. I will need some kind of user interface to do these updates. If there is a free application you know of that can help with updates to mysql tables and can work with my setup, you can incorporate this if we can both agree on it. Note: The main table, already part of [url removed, login to view], is over 5 million records so your update procedure and test server site will have to have sufficient to accomodate this. This system currently runs adequately fast and I will not accept a reduction in performance (time it takes to retrieve data during search) after all the new tables are added, so proper indexing and linking of tables is a must. I also would like this project finished in less than 1 week after you would begin. I will be available every day for questions.

Beceriler: Her şey Kabul, Veri Tabanı Yönetimi, Düzenleme, Microsoft Access, MySQL

Daha fazlasını görün: need help for excel editing, mysql search performance, mysql database server, mysql database for free, mysql database application, free mysql server, find a master, application performance report, summation excel, microsoft project free, microsoft excel test, microsoft access test, excel summation, delete searches, mysql free, free mysql, mysql test, mysql report, mysql database , database queries, database performance , database in excel format, mysql code search, duplicate table, mysql add fields

İşveren Hakkında:
( 4 değerlendirme ) Saint Augustine, United States

Proje NO: #2234819