You are a database developer for a container manufacturing company.
The containers produced by your company are a number of different sizes and shapes.
The tables that store the container information are shown in the Size, Container, and Shape Tables exhibit.
A sample of the data stored in the tables is shown in the Sample Data exhibit.
Periodically, the dimensions of the containers change. Frequently, the database users require the volume of a container.
The volume of a container is calculated based on information in the shape and size tables.
You need to hide the details of the calculation so that the volume can be easily accessed in a SELECT query with the rest of the container information.
What should you do?
No description found.