Block 2 Quiz and Database Management

Question 1

a.Take a screenshot of the question navigation panel from the Block 2 quiz, showing the full extent of your engagement with the questions. Your screenshot should look similar to Figure 1. Paste the screenshot into your solution document as your answer to this part of the question.

b.You should write no more than 90 words for this part of the question.

Write a few sentences in which you tell your tutor about your experience of completing the quiz. For instance, you may have found some Block 2 quiz questions particularly interesting or challenging. In that case, tell your tutor why you found these questions challenging or interesting. Think of this as an opportunity to communicate with your tutor about your experience of studying Block 2.

This question can be answered after you have completed your study of Block 2 Part 3 and any related activities within that part.

It is intended to allow you to show your understanding of the context of data management and the features found in a modern database management system. In addition, you should be able to show that you understand the importance of data independence and how that relates to the three-schema data architecture.

a.State why data has both cost and value to an organisation.

b. Briefly explain why a database management system (DBMS) is much more than just a database

c.An existing relational database, developed in accordance with the three-schema architecture, is supporting several application processes 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 process requires a new table in the database and uses none of the existing tables.

2.A new application process is required that uses data already in use by an existing application process. 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 application processes; no existing application process uses all these tables.

For each of these application’s external schema 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 application processes and justify your answer.