Answered step by step
Verified Expert Solution
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started