A set of operations that do not need to be fully completed

A logical unit of work on the database

A series of incomplete actions on the database

A physical unit of work on the database

A user is referred to by authorization ID, typically their login name.

You may grant privileges to other users (authorization ID’s), including PUBLIC

Granting a privilege to PUBLIC makes it available to any authorization ID.

You may not grant privileges WITH GRANT OPTION, which lets the grantee also grant this privilege.

DROP

INSERT

SELECT

UPDATE

A set of relationships between tables in a database

A set of rights that allow users to perform certain actions on database objects

A set of SQL commands used to manage database objects

A set of files and directories on a file system

To track changes made to the database

To limit user access to data

To customize access based on the user's department or purpose

To create SQL roles that can transfer privileges to other users

The process of creating a new view by combining data from multiple tables

The process of  storing the result of a query physically and update the data periodically.

The process of modifying the structure of a view without affecting the underlying tables

The process of restricting access to a view based on user permissions

Increased complexity of the database schema

Improved security by limiting access to specific data

Slower database performance

Reduced data independence

CREATE VIEW sales_view AS

SELECT salesperson, product, MAX(sale_amount) AS total_sales

FROM sales

GROUP BY salesperson, product;

CREATE VIEW sales_view AS

SELECT salesperson, product, AVG(sale_amount) AS total_sales

FROM sales

GROUP BY salesperson, product;

CREATE VIEW sales_view AS

SELECT salesperson, product, SUM(sale_amount) AS total_sales

FROM sales

GROUP BY salesperson, product;

CREATE VIEW sales_view AS

SELECT salesperson, product, sale_amount

FROM sales

GROUP BY salesperson, product;

CREATE VIEW customer_orders_view AS

SELECT customer_name, order_id, total_amount

FROM customers

LEFT JOIN orders ON customers.customer_id = orders.customer_id;

CREATE VIEW customer_orders_view AS

SELECT c.customer_name, o.order_id, o.total_amount

FROM customers c

LEFT JOIN orders o ON c.customer_id = o.customer_id;

CREATE VIEW customer_orders_view AS

SELECT c.customer_name, o.order_id, o.total_amount

FROM customers c

JOIN orders o ON c.customer_id = o.customer_id;

CREATE VIEW customer_orders_view AS

SELECT customer_name, order_id, total_amount

FROM customers, orders

WHERE customers.customer_id = orders.customer_id

GROUP BY customers.customer_id;