A table STUDENT already exists with all columns but no primary key. SQL for each of the following:

a) add a column named dob (data type date and always requires value), and

b) create a composite primary key using columns G-Number and dob