Explore BrainMass
Share

SQL Command to Add MATH SCOPE to the STUDENT Table

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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 ad1c9bdddf
https://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