Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Database administration is an important element of database planning. Security and performance issues need to be considered prior to the actual implementation of the database

Database administration is an important element of database planning. Security and performance issues need to be considered prior to the actual implementation of the database in the production environment. Write a Database Administration Plan. Complete the following:

  • Use data control language (DCL) to control access to the data by writing structured query language (SQL) statements to add a group of 5 users who have been granted permission to perform specific system privileges (CREATE object) and object privileges (INSERT, SELECT, UPDATE, and EXECUTE).

     

Customers customer_id INT PRIMARY KEY, first name VARCHAR(50) NOT NULL last name VARCHAR(50) NOT NULL, email VARCHAR(50) UNIQUE, phone VARCHAR(20) UNIQUE Employees employee id INT PRIMARY KEY, first name VARCHAR(50) NOT NULL last name VARCHAR(50) NOT NULL email VARCHAR(50) UNIQUE, phone VARCHAR(20) UNIQUE 1 1... 1..." Appointments appointment_id INT PRIMARY KEY, customer_id INT NOT NULL, FOREIGN KEY appointment date DATE NOT NULL appointment time TIME NOT NULL, duration INT NOT NULL, 1 Billing billingid INT PRIMARY KEY, customer_id INT NOT NULL, FOREIGN KEY service price DECIMAL(10,2) NOT NULL service_date DATETIME NOT NULL

Step by Step Solution

3.40 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

1 Create a new database user group called dataentryusers CREATE GROUP dataentryusers 2 Grant the dat... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information System

Authors: James A. Hall

7th Edition

978-1439078570, 1439078572

More Books

Students also viewed these Databases questions

Question

What is the likelihood function for a logistic regression model?

Answered: 1 week ago

Question

What are the computer ethical issues regarding misuse of computers?

Answered: 1 week ago

Question

=+a. Construct a Youden plot of this data.

Answered: 1 week ago