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?

242.

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?

Create a stored procedure that requires ContainerID as an argument and returns the volume of the container

Create a user-defined function that requires ContainerID as an argument and returns the volume of the container.

Add a column named volume to the Container table. Create a trigger that calculates and store the volume in this column when a new container is inserted into the table.

Add a computed column to the Container table that calculates the volume of the container.

View Description

No description found.