Consider the SQL example in Figure 1-19.

Figure 1-19

Figure 1.20

a. What is the name of the table that is referred to when the SELECT statement is executed?

b. How many tables are accessed when the FROM statement is executed?

c. How many conditions are evaluated and met in order to display the details shown in Figure 1-20?

Transcribed Image Text:

CREATE TABLE Product_T (ProductID Product Description ProductFinish ProductStandard Price ProductCost Product Prior YearGoal ProductCurrentYearGoal ProductLineID FOREIGN KEY NUMBER(11,0) NOT NULL PRIMARY KEY VARCHAR (50), VARCHAR (20), DECIMAL (6,2), DECIMAL, DECIMAL, DECIMAL, VARCHAR (40), (ProductLineID) REFERENCES ProductLine_T (ProductLineID));