2. Write the SQL command to add SUBJECT to TUTOR. The only values allowed for SUBJECT will be "Reading", "Math", and "ESL".© BrainMass Inc. brainmass.com March 21, 2019, 7:52 pm ad1c9bdddf
1. The proper SQL command for inserting a column into a table is:
ALTER TABLE [table_name]
ADD [col_name] [datatype];
For the first SQL command, the [col_name] we want to add is MATH_SCOPE and the [table_name] is STUDENT. Here, I assume the datatype for MATH_SCOPE will be varchar(20), this represent a variable length string. Although, this datatype may be different for you ...
Provides steps necessary to add MATH SCOPE to the STUDENT table.