Add the following fields in the Table ‘SUBJECT’ – SUBJECT_ID, SUBJECT_NAME, AUTHOR_ID. Add 15 records in the table. 

To add the fields SUBJECT_ID, SUBJECT_NAME, and AUTHOR_ID to the existing SUBJECT table, and insert 15 records into it, we would follow a series of steps in a practical database management context, specifically using SQL.

Step 1: Alter the Table to Add New Columns

To begin, you need to modify the structure of the existing table to include the new fields. In SQL, the ALTER TABLE command is used to make changes to an existing table's structure. The command will add three new columns to the SUBJECT table:

 ALTER TABLE SUBJECT ADD COLUMN SUBJECT_ID INT PRIMARY KEY, ADD COLUMN SUBJECT_NAME VARCHAR(255), ADD COLUMN AUTHOR_ID INT; 

• SUBJECT_ID INT PRIMARY KEY: This field is used to uniquely identify each subject. It is defined as an integer and will serve as the primary key.
________ ________ ___ __________ ___ ___.
______ ___ ___ __________ ________ __________ _________ _________ _________ _______ ________ _____.
__________ _____ _______ _________ __________ ______ _________ ______ _______ _______ __________ _________.
_____ _________ _________ _______ _________ _________.
___ ______ __________ _______ _________ ___ ____ ______ __________ ______ _____.
____ ____ ___ ________ __________ ______ ____ __________ __________ ___.
______ ______ ___ __________ ____ _______ ___ ______ ______ _______ _________.
______ ______ _____ ______ ___ _______ ________ ___ __________ _______ __________ ________.
_________ ___ _______ _______ _______ _________ ___.
________ _______ ______ _______ _________ _______.
___ __________ ________ __________ _______ ___ __________ _____ ___ ________.
_______ ___ _________ _________ _______ __________ _____.
__________ ____ _____ _______ _______ __________.
____ ____ __________ _______ _______ ___ ____ ________.
________ ________ ______ ___ ____ _______ __________.
_________ _______ ____ ______ _________ ______ _________ _______ _____.
__________ _____ ____ ______ __________ ________ _________ _______ _________ ____ __________.
_______ ________ ___ ________ ____ ______ _____ _______ ___.
______ _____ ________ ________ __________ _________ _________ _________ __________.
__________ __________ ____ _______ _____.
_________ ________ _______ ____ ________.
________ _____ __________ _________ ______.
________ __________ ________ _________ ___.
____ ______ ______ _________ ___.
___ _____ _______ _________ _____.
_____ _______ ______ __________ _______ _________ ___ ______.
______ __________ _____ ___ ___ _______ _________ _________ _________ ________.
_______ ____ __________ _____ ___ ______ _________ __________ ___ _____.
_________ _____ __________ ___ ________ ___ ____.
___ ______ __________ ___ _______ ____.
___ ________ _______ _____ ________.
_______ ___ __________ _____ ________ ______.
_________ ___ _______ __________ ____ __________ __________ __________ _________ _____ ________ ________.
_____ _________ ____ ___ _______ __________ ________.
_________ ______ _____ _____ ___ ____ _______ _____.
_____ _________ ________ ________ ___ _____ ___ _____ ____.
_____ ___ ____ ____ ___ ________ ________ ______ ______ ___ __________.
___ ______ _______ ______ __________ ___ ______ _____ ________ _______.
_______ ________ _______ _______ _______ ____ ______ ______ _______ ___ ___ _____.
__________ ______ ______ _________ _______ ___ ______.
___ __________ _____ __________ ___.
_________ __________ _______ ______ _______ _____ ______ ______ _____.
________ _____ ________ __________ ____ ______ ________ _______ ______.
________ _____ _________ _____ _______ ____ ________ ___ _______ ___.
___ ___ ________ _____ _________ _________ ________ _______ ___.
_______ ________ _______ ________ _________.
__________ ____ __________ _______ ______ _________ ______ __________ __________.
__________ _______ ________ ____ _______ ________ _____ _________.
___ _______ __________ _______ __________.
__________ _____ __________ _________ _____ _____ ____.
________ __________ ___ __________ ______.
_________ ___ _________ ____ ________ ________ __________ __________.
___ ________ __________ ____ ___ ______ ____ ____.
_______ ___ _________ ________ _______ _________ ____ ____ _____ ______ _________.
___ ______ ______ _______ __________ _________ ________ _____ ___ ______ ____ ______.
_______ ________ ____ _________ ______.
____ _______ ___ _________ ______ __________.
______ ________ _________ ________ ___.
__________ ___ _______ ______ _______ _____ _________ ___ ________.
_____ ___ _________ ___ ___ _____.
______ _________ __________ ____ _______ __________.
_____ ______ _______ ______ ____ __________ __________ ___ ________.
_________ _________ ___ __________ __________ ____ _________ ___ _______ ____ _________.
__________ ____ ________ ______ _______ ______ ________ ______.
___ _____ ________ _____ _____ ____ __________ ________ ______ ____ ____.
__________ _______ _______ _________ _________ __________ ________ __________.
__________ _____ ______ _______ __________ __________ ____ ____ _________ ____ ___.
________ __________ ________ ________ _______ __________ _______ ________ __________ ________ _____ ______.
_______ _______ ______ __________ _________ ____ ________.
_______ ____ ___ ____ ____ ________ ______ ___ _______.
_________ ______ _______ _____ _____ _______.
_______ _____ ________ __________ ______ _______ _________ __________ ________ _____ ______ ________.
____ ________ ____ ______ ________ ______ ___ ___.
________ _____ _______ _______ _________ _______ ____.
__________ _______ ________ _______ _____ _____ ______ ____ ___ __________ ____.
_________ _____ _________ _________ ________ _______ _____ _________ _______ _______.
________ __________ ______ ______ ___ ____ ________ _______ ___ ______.
__________ ________ ______ _____ ________.
_____ ________ ______ ______ __________ _______ ____ ______.
_______ _____ ______ ___ ______ ______ _____ ______ ______ ________ ___.
_______ ____ ____ __________ ___.
___ ________ ______ ___ __________ ___.
___ __________ __________ _________ ____.
Get Full Answer on WhatsApp