Explore BrainMass

Explore BrainMass

    SQL Command to Add MATH SCOPE to the STUDENT Table

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    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 December 24, 2021, 8:46 pm ad1c9bdddf

    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.