Question: 50 marks Section B (Database Design and Administration) Question B1. Database Administration (10 marks) (a) (3 marks) What are the 3 fundamental operations that are

50 marks Section B (Database Design and Administration) Question B1. Database Administration (10 marks) (a) (3 marks) What are the 3 fundamental operations that are performed in a database? (b) (4 marks) What are the primary job responsibilities of a DBA (c) (3 marks) A database must be designed to store the correct data in the correct way without that data becoming damaged or corrupted. Describe the three aspects to ensuring data integrity, (0) Physical (ii) Semantic and (ii) Internal Integrity. Question B2. Data and Storage Management (10 marks) (a) (1 Mark) Reliable storage is critical in ensuring a Database System meets operational requirements. What does the acronym RAID mean? (b) (6 Marks) Describe the following 3 RAID Storage strategies and how they are implemented. Use a diagram to illustrate your understanding. (6 Marks) a. RAID -1 b. RAID-5 c. RAID-10 (c) (3 Marks) RAID Levels and Performance are important considerations in choosing storage, describe briefly the key metrics when selecting RAID types. Question B3. Database Environment (10 marks) (a) (3 Marks) The Transaction Processing Performance Council is an independent not for profit organisation that manages and administers performance benchmark tests. a. What is TPC-C b. What is TPC-H c. What is TPC-E (b) (1 mark) What are the potential risks of upgrading to a new DBMS release without a plan? (c) (4 marks) Describe the 4 levels of DBMS architecture? (d) (2 marks) Five key requirements must be planned when installing a new DBMS describe 3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Questions Answer all questions (b) Discussing the implications of the questioned amounts including payment to Excel Plc and the likely principle tax liability if any. (25 marks) (c) Explaining the...

Help me solve all the questions below Question 3 (a) (b) Over the years, the Government of Uganda has undertaken many finance and payroll reforms including the implementation of Integrated Finance...

The following trial balance was prepared by the Authority as at 31 December, 2016. Shs 'million' Shs 'million' Leasehold property at valuation 31 December, 2015 1,120 Land 200,130 Power stations...

(a) Multex Industries Ltd (MIL) operates in several sectors in the country, including manufacturing, retailing, oil, wholesale and construction to mention but a few. On 1 January, 2018 MIL disposed...

Question 1 Efex Bank Uganda Limited (EBUL) is a commercial bank that has operated in Uganda for the past twenty five years. The bank was among the first financial institutions to be licensed by the...

ANSWER ALL THE QUESTIONS Question 1 Khaki & Sons Limited (KSL) is a family business that deals in car spare parts. It is one of the largest dealers in car spare parts in Uganda. Since inception in...

Please use C++ for this program. Please read the problem and follow the instruction in main.cpp for this program. Problem: - Design an abstract class called Shape: - Private variables double x and...

Data gistrun sending inside a pack fills in as conventional allowing subordinate rules to execute on progressive clock cycles. Correspondence between gatherings conventionally causes a surprising...

lup ] (d) Show how a generating (or "mother") wavelet (x) can spawn a family of "daughter" wavelets jk(x) by simple shifting and scaling operations, and explain the advantages of representing...

In an attempt to avoid liquidating the company, the management of Carter, Inc., is considering a reorganization that calls for the restructuring of $2,100,000 of debt maturing in three years and...

Why are - and R-charts usually used hand in hand?

Test - Intermediate Casualties ( 2 0 2 5 ) Miscellaneous uestion 1 4 of 1 5 . Wich statement is CORRECT for federally declared disaster area casuallies? A taxpayer may choose to deduct the disaster...

The allowance for uncollectible accounts is a:

What would be an example of a staff function that has been coopted by operations? What would it take to reclaim its independent role?

In addition to patterns of interaction, in what ways are organizational structure and strategy responsible for the managerial climate?

What would be an example of line responsibilities that have been inappropriately assumed by a staff function? What would it take for the line operations to reclaim their appropriate role?