SQL Database On Mobile Device
We need a coder able to work remotely on a database project. The coder must be exceptionally experienced in working with databases. The project consists of combining two database tables while eliminating any duplicate record entries. There are two database tables, one named “Data_New” and the other name “Data_Store”. Information is constantly being entered into Data_New. At irregular intervals the content of Data_New is transferred to Data_Store.
Prior to combining the two database tables, we will require a piece of code that will compare the contents of Data_New, record by record with Data_Store. If Data_New has a record that is already in Data_Store, that record will be deleted from Data_New. After all the detected duplicate records has been deleted from the Data_New table, the remaining record in the Data_New table are appended to Data_Store table.
There are 7 fields in each of the record of the two tables (Data_New and Data_Store) that need to be compared, if there is a match, the record in the Data_New table is to be deleted. Once all of the duplicates are deleted from the Data_New table, the remaining unique records in the Data_New table are appended to the Data_Store table. After the records are appended to the Data_Store table, all the records in the Data_New table are deleted.
If you have experience is doing this type of project contact me. In your contact, indicate how many hours you think this will take to do.
Posted On: September 14, 2021 06:46 UTC
Category: Mobile App Development
Skills:Phone, Tablet, SQLite, Kotlin, Java, Android, MySQL, Android App Development
Country: United States
click to apply