Add the following fields in the Table 'SUBJECT'

Question

Add the following fields in the Table 'SUBJECT' - SUBJECT_ID, SUBJECT_NAME, AUTHOR_ID. Add 15 records in the table.

22 Jan 2025

Answer :

Word Count : 773

To add the required fields and records to the table "SUBJECT" in a database, first, let us break down the task and go through the necessary steps to understand the operations and the rationale behind them.

### Step 1: Altering the Table to Add Fields
Before adding any records, we need to modify the existing "SUBJECT" table by adding the new fields. The fields that need to be added are `SUBJECT_ID`, `SUBJECT_NAME`, and `AUTHOR_ID`.

- SUBJECT_ID: This is likely a unique identifier for each subject. It will be a primary key or at least a unique key for each subject entry.
- SUBJECT_NAME: This will store the name of the subject.
- AUTHOR_ID: This refers to the unique identifier of the author of the subject, suggesting that the subject may be created or curated by an author, and the relationship between the subject and the author should be maintained.

To alter the table structure, the following SQL query is used:

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

Explanation:
- `SUBJECT_ID INT PRIMARY ______ __________ ______ ___ _____ _________ _______.
_____ ____ ________ _________ _______ ________.
______ _______ _________ _______ ___ __________ _________.
_________ ____ _______ __________ _____ __________ ______ ___.
__________ ____ ___ _________ _____ ________ ______.
_______ ________ ______ ___ _________ ____ ____ _______ __________ _____ _____.
_____ ____ ____ __________ ________.
__________ ______ ____ _________ _____ _________.
__________ __________ _______ _________ _______ ______ _______ ____ __________ _______ ________.
_______ ____ ____ ________ _____ __________ __________ _____ _______ _______ ________ _______.
_________ ______ ______ _______ _____ ______ ______ _________ _________ ___ ________ _______.
____ ___ ____ _________ ________ ____ ______ ______ __________ _________ __________.
__________ ___ ___ _________ _________ ___ ______ ____ _____ _________ _________.
___ _________ __________ _______ _____ __________ __________ _________ __________.
______ ________ ___ __________ ______ ____ ___ _______ ___ ___ __________.
_______ __________ ___ ______ _________ ___ ______.
____ ____ _______ _____ ______ _____ ________.
__________ _____ ________ ____ ___ _____ ___ ________ ____.
_____ ___ ________ ____ __________ ______ ___.
________ ____ ______ _________ ___ _____ _________ _______ _______ _____ __________ _________.
__________ ___ __________ ______ _______ ________.
______ _______ ___ _________ ______ _________ _____ ___ _______ __________.
__________ __________ _____ ______ ____.
________ _________ ______ ________ ____ _______ ____ ___ _________ _______ _______.
_____ __________ ________ _________ ____ __________ ____.
__________ _________ _______ ______ _______ _____ ________ ______ ___.
___ _________ __________ ____ ___ ______ ___.
________ _______ _________ _______ ________ ________ __________ _________ ___ ____ ___ _________.
_____ ___ _____ _________ _____ ______ _______ ___ _______.
_________ ___ ________ _________ ________ _________ ___ _________.
_____ ____ ______ ___ ________ ________ _______ ____.
____ ______ _____ ____ ___ ____ _______ _______.
_________ ___ _________ __________ _____ _____ ___ _______ __________ ____ ________.
_______ _____ __________ _____ _______ _________ _____ _________ ___ _______.
________ __________ _________ ____ __________ _____.
_______ ______ ____ __________ _____ ___ _____.
________ ___ ______ ___ __________.
_____ _____ __________ ____ ________ _______ ________ _______.
__________ ________ ______ _________ _________ ______ ________.
_____ _____ ____ _______ ___ _________ _____ ___.
_______ ________ ________ ______ ___ ________ _________ _______.
_____ ___ ___ ___ __________ ____ _____ _______ ______ ________ _______ _________.
_________ _____ _____ ___ ____ _________ ___.
___ ______ ____ ____ _______ ______ ________ _________ ____ ______ ______ _______.
_________ _______ _____ ____ ______ _______ ___.
_____ _____ _________ _________ _______ __________ ________.
________ _________ _______ _______ ______ __________.
_________ __________ __________ ______ ___ ____ ___ _______.
_____ ___ ___ ________ __________ ________.
______ ___ __________ _______ __________ ______.
________ ____ _____ _______ ______ _______ ___ __________ ________.
_____ _______ _____ ___ ________ __________.
__________ __________ ____ ___ ________ _________.
________ ______ _____ ______ _______ ____ ________ _______ _____ _____ ________ _______.
_____ ___ ____ _________ _________ _____ ____.
__________ ____ _______ __________ __________ _____ ____ ____.
_________ _____ ______ ___ __________ ____.
____ _________ ________ _______ _______ _____.
____ _______ _______ __________ ________ ______ _________ __________ ____.
_________ __________ ___ __________ ________ ______ __________ ________ _______ _________ ___.
__________ _________ ____ ________ _______ _____ ________ ___.
___ ________ _____ _________ ____ ______ _____.
____ _________ _________ ____ ________.
______ _______ ______ _______ _____ ____ ________.
_____ __________ ______ _______ _______ ___ ________ _____.
_____ _________ ______ _____ _____ ________ ________.
_________ _____ ____ __________ ____ __________ __________.
____ _______ _____ _______ _____ __________ ______ ___ ____ ________.
________ _____ ________ ________ _________ _____ _________ _________ _________ _______ ____.
_____ _____ ____ __________ _______ _______.
_________ __________ _______ _______ _______ _______ _______.
Get Full Answer on WhatsApp

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers

IGNOU NEWS

Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★