The global schema, fragmentation schema, and allocation schema.

SQL commands for above queries/applications

How the response for application 1 and 2 will be generated. Assuming these are global queries. Explain how various fragments will be combined to do so.

Implement the database at least using a centralized database management system.