Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. State why data has both cost and value to an organisation. (2 marks) b. You should write no more than 150 words for this

image text in transcribed

a. State why data has both cost and value to an organisation. (2 marks) b. You should write no more than 150 words for this part of the question. Briefly explain why a database management system (DBMS) is much more than just a database (6 marks) c. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Semantics In Databases Second International Workshop Dagstuhl Castle Germany January 2001 Revised Papers Lncs 2582

Authors: Leopoldo Bertossi ,Gyula O.H. Katona ,Klaus-Dieter Schewe ,Bernhard Thalheim

2003rd Edition

3540009574, 978-3540009573

More Books

Students also viewed these Databases questions

Question

Share information.

Answered: 1 week ago

Question

Write an Individual Report on Working in International Teams.

Answered: 1 week ago

Question

=+j Explain IHRMs role in global HR research.

Answered: 1 week ago

Question

=+j Describe an effective crisis management program.

Answered: 1 week ago