Managing Database

Info Super Corp. has two databases with a common table employees. These two databases are located at the company's offices in New York and Atlanta. Client computers connect to the databases to make changes. If employees join at the New York office, the information pertaining to them should be available at the Atlanta office as well. The two databases are accessible from either of the company office. You as the database administrator need to check that any data inserts or modifications are made in the common table and the changes are reflected at both locations. How will you perform this operation?

Also, provide answers with critical reasoning on the following:

Suppose, Info Super Corp. has added $10$ users and modifies $3$ existing users in the "USER" database stored in MySQL$.$ There are different users concurrently accessing the USER database. To avoid data discrepancy, you have been told to update the database with the changes immediately. How will you attain this?

While doing the above task, by mistake you delete some of the rows of a MySQL database. Is it possible to recover some of the rows of a MySQL database after successful execution of a DELETE operation? If you agree, how will you do it$?$ If you disagree, is it possible to introduce that kind of support at the database level?

While managing and logging all data changes, how will you pull aggregate data for both branches to create reports?