1. Write the SQL command to add MATH SCOPE to the STUDENT table.
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 December 24, 2021, 8:46 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.