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;

Cleaning duplicate records from a database

Extracting data from websites automatically

Uploading documents to cloud storage

Encrypting customer records

APIs replace the need for relational databases

APIs store historical business records

APIs allow real-time data access from external sources

APIs prevent businesses from storing data