an exisiting relational database, developed in accordance with the three schema architecture, is supporting several applications that share data. Some new requirements are identified by the database users that result in new applications being developed as follows:

1) a new application requires a new table in the database and uses none of the existing tables.

2) a new application is required that uses exactly the same data already being used by an exisiting application. however, the performance requirements for the new application require the database to use new hardware so the data retrieval is more efficient.

3) a new application uses tables already in the database that are currently in use by different exisiting applications; no exisiting applications uses all these tables.

for each of these applications external schema requirements:

i) state what changes would be required (if any) to each of the exisiting schemas in the three schema architecture and state why that change is required.

ii) state whether or not the required schema changes would affect any exisiting applications and justify your answer.