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?
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?
Fundamentals of Information Systems
8th Edition
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter3: Database Systems And Applications
Section: Chapter Questions
Problem 3PSE
Related questions
Question
Transcribed Image Text: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.
Transcribed Image Text: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?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning