Describing the database components
There are components in a relational database that are important to maintain the organization and productivity. The four most common components among database systems are as follows:
- Views
- Stored Procedures
- Triggers
- Indexes
Let’s take a look at each of them in detail in the following sections.
Views
A view can be considered a virtual table because it is composed of rows and columns of data, the results of a SELECT SQL instruction in one or more database tables. Views are great resources for organizing information from different tables to create reports.
The following is a view example, with the name High_price_products, which is constructed with a SELECT statement in the PRODUCTS table, filtering the Price field by the average greater than that of the other products in the table:
CREATE VIEW [High_price_products] AS
SELECT Product_Name, Product_Price
FROM Products
WHERE Product_Price > (SELECT AVG(Product_Price...
