There are two tables courses
and teachers
, given below. Write a set of SQL statements to add these new columns to specified tables.
table | new column name | data type | constraint |
---|
courses | startedIn | INTEGER | DEFAULT 2015 |
teachers | courseId | INTEGER | NOT NULL, DEFAULT 1 |