BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 16, Problem 23RQ
Textbook Problem
311 views

Assume that your company has assigned you the responsibility of selecting the corporate DBMS. Develop a checklist of the technical issues and other aspects involved in the selection process.

Program Plan Intro

Database Administrator (DBA's):

The person responsible for the maintaining the shared and centralized database is known as Database Administrator (DBA).

The role and responsibilities of the DBA varies from organization to organization based on the size of the organization. Based on the organization, DBA defined either in line position or staff position.

The DBA’s technical role needs the functions of database management system (DBMS), structure, programming languages, and methodologies of data-modeling and design.

Explanation of Solution

Checklist for technical and other aspects in selection process:

The important technical responsibility is choosing the DBMS, utility system, hardware which is utilized in organization.

The checklist is developed for desired DBMS features addresses the following issues,

  • DBMS model – Are Company’s wants the better model which served by relational, object-oriented, or NoSQL DBMS?
  • DBMS storage capacity – What maximum disk and sizes of database are needs?
  • Application development support – Which programming languages are used?
  • Security and integrity – Does the DBMS use the rules of referential and entity integrity, and access rights?
  • Backup and recovery – Does the DBMS offer automated backup and recovery tools?
  • Concurrency control – Does the DBMS offer...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 16 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
add
Ch. 16 - Describe the DBAs responsibilities.Ch. 16 - How can the DBA function be placed within the...Ch. 16 - Why and how are new technological advances in...Ch. 16 - Explain the DBA departments internal organization...Ch. 16 - Explain and contrast differences and similarities...Ch. 16 - Explain how the DBA plays an arbitration role...Ch. 16 - Describe and characterize the skills desired for a...Ch. 16 - What are the DBAs managerial roles? Describe the...Ch. 16 - What DBA activities support end users?Ch. 16 - Explain the DBAs managerial role in the definition...Ch. 16 - Protecting data security, privacy, and integrity...Ch. 16 - Discuss the importance and characteristics of...Ch. 16 - Assume that your company has assigned you the...Ch. 16 - Describe the activities that are typically...Ch. 16 - Why are testing and evaluation of the database and...Ch. 16 - Identify some bottlenecks in DBMS performance, and...Ch. 16 - What are typical activities in the maintenance of...Ch. 16 - How do you normally define security? How is your...Ch. 16 - What are the levels of data confidentiality?Ch. 16 - What are security vulnerabilities? What is a...Ch. 16 - Define the concept of a data dictionary, and...Ch. 16 - Using SQL statements, give some examples of how...Ch. 16 - What characteristics do a CASE tool and a DBMS...Ch. 16 - Briefly explain the concepts of information...Ch. 16 - Identify and explain some critical success factors...Ch. 16 - How have cloud-based data services affected the...Ch. 16 - What tool is used in Oracle to create users?Ch. 16 - In Oracle, what is a tablespace?Ch. 16 - In Oracle, what is a database role?Ch. 16 - In Oracle, what is a datafile? How does it differ...Ch. 16 - In Oracle, what is a database profile?

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What does the term 3 Vs refer to?

Database Systems: Design, Implementation, & Management

List the two most common methods for measuring surface finish.

Precision Machining Technology (MindTap Course List)

What are the equivalent present worth and future worth of the cash flow given in Problem 20.17? Assume i = 8%.

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Explain Apple’s view of user interface design, especially for apps.

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

Compute the moment amplification factorB1 for the member of Problem 6.2-2. a. Use LRFD. b. Use ASD.

Steel Design (Activate Learning with these NEW titles from Engineering!)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

Assistive Technologies You have just purchased a new computer and, because of a visual impairment, you are havi...

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

Why should you never change the current setting during a weld?

Welding: Principles and Applications (MindTap Course List)