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

Figures 1-18

Figures 1-19

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

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

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

d. In Figure 1-19, explain the purpose of the NOT NULL specification associated with Product ID.

Transcribed Image Text:

CREATE TABLE ProductLine_T (ProductLineID VARCHAR (40) NOT NULL PRIMARY KEY, PIPriorYearGoal DECIMAL, PICurrent YearGoal DECIMAL);