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).

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

1 Create a new database user group called dataentryusers CREATE GROUP dataentryusers 2 Grant the dat... View the full answer