Answer the following questions concerning Figures 1-17 and 1-18:

Figures 1-17

Figures 1-18

a. What will be the field size for the ProductLineName field in the Product table? Why?

b. In Figure 1-18, how is the ProductID field in the Product table specified to be required? Why is it a required attribute?

c. In Figure 1-18, explain the function of the FOREIGN KEY definition.

Transcribed Image Text:

CREATE TABLE ProductLine_T (ProductLinelD VARCHAR (40) NOT NULL PRIMARY KEY, PIPriorYearGoal DECIMAL, PICurrentYearGoal DECIMAL);