15. What are the DBA's database design responsibilities 16 What is the difference between production and test systens? 17. What is meant by tuning a design?" 18. How can splitting a table improve performance? 19. What is denormalization? 20 You are employed as a DBA for a medical practice. You have implemented multiple safeguards to protect patient privacy and conform to HIPAA regulations. What other practical, common-sense measures should you take to ensure that the database system is secure? ldentify at least three measures and explain the purpoe of each one. If you use information from the Web, use reputable sites. Do not plagiarize or copy from the Weo. 21. For credit card processing, stock exchanges, and airline reservations, data availability must be continuous. There are many other examples of mission-critical applications. Research the Internet to find four additional mission-critical applications and explain why data availability must be continuous for these applications. If you use information from the Web, use reputable sites. Do not plagiarize or copy from the Web. Be sure to cite your CAITICAL THINKING /CaITICAL THINKING nou references. BITS Corporation Exercises For the foilowing exercises, you do not use the BITS database. 1. Write the SQL for the following privileges as they related to the Client table: a. Give all rights to sburton. b. Give insert, delete, and update rights to creneau. c. Give select rights to Ineilson. d. Revoke delete privileges to sburton. e. Revoke the ability to add constraints or change the table definition to tknudsen. 2 The DBA asks for your help in planning the data archive (not backup) for the following BITS database: Consultant (ConsltNum, LastName, FirstName, Street, City, State, ZipCode, Hours, Rate) Client (ClientNum, ClientName, Street, City, State, ZipCode, Balance, CreditLimit, ConsltNum) WorkOrders (OrderNum, OrderDate, ClientNum) OrderLine (OrderNum, TaskID, ScheduledDate, QuotedPrice) Tasks (TaskID, Description, Category, Price) Determine which data from the database to archive; that is, for each table, specify whether data needs to be archived. If it does, specify which data, when it should be archived, and whether it should be archived with data from another table. Database Administration 3. The DBA denormalized some of the data in the BITS database to improve performance, and one of the resulting tables is the following: Client (ClientNum, ClientName, Street, City, State, ZipCode, Balance, CreditLimit, ConsltNum, ConsltName) Which field or fields cause the table no longer to be in third normal form? In which normal form is the denormalized table?