Answered step by step
Verified Expert Solution
Question
1 Approved Answer
An existing relational database, developed in accordance with the three-schema architecture, is supporting several applications that share data. Some new requirements are identified by the
An existing 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 existing application. However, the performance requirements for the new application require the database to use new hardware so that data retrieval is more efficient. 3. A new application uses tables already in the database that are currently in use by different existing applications, no existing application uses all these tables. For each of these application's requirements: I. state what changes would be required (if any) to each of the existing 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 existing applications and justify your
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started