A possible DDL corresponding to Figure 3.1 is shown below:

Discuss the following detailed design decisions:
a. The choice of requiring NAME to be NON NULL.
b. Selection of SSN as the PRIMARY KEY.
c. Choice of field sizes and precision.
d. Any modification of the fields defined in this database.
e. Any constraints on individual fields.

Transcribed Image Text:

NAME SSN HOMEPHONE VARCHAR(14) ADDRESS OFFICEPHONE VARCHAR(14) AGE GPA VARCHAR(30 NOT NULL CHAR(9) PRIMARY KEY, VARCHAR(40), INT DECIMAL(4,3