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