Answer the following questions concerning Figures 1-16 and 1-17: FIGURE 1-16 SQL definition of ProductLine table CREATE TABLE ProductLine T (ProductlinelD VARCHAR (40) NOT NULL PRIMARY KEY,...

Extracted text: Answer the following questions concerning Figures 1-16 and 1-17: FIGURE 1-16 SQL definition of ProductLine table CREATE TABLE ProductLine T (ProductlinelD VARCHAR (40) NOT NULL PRIMARY KEY, PIPrlorYearGoal DECIMAL, PICurrentYearGoal DECIMAL); FIGURE 1-17 SQL definition of Product table CREATE TABLE Product T (ProductiD NUMBER(11,0) NOT NULL PRIMARY KEY ProductDescription VARCHAR (50), ProductFinish VARCHAR (20), ProductStandardPrice DECIMAL(6,2), ProductCost DECIMAL, ProductPriorYearGoai DECIMAL, ProductCurrent YearGoal DECIMAL, ProductLinelD VARCHAR (40), (ProductLinelD) REFERENCES ProductLIne T (ProductLineID)); FOREIGN KEY a. What will be the field size for the ProductLineName field in the Product table? Why? b. In Figure 1-17, how is the ProductID field in the Product table specified to be required? Why is it a required attribute? c. In Figure 1-17, explain the function of the FOREIGN KEY definition.