SQL Command to Add MATH SCOPE to the STUDENT Table
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 March 21, 2019, 7:52 pm ad1c9bdddfhttps://brainmass.com/computer-science/sql/sql-command-add-math-scope-student-table-311681
Solution Preview
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 ...
Solution Summary
Provides steps necessary to add MATH SCOPE to the STUDENT table.
$2.19