Question
Operations:
CRUD (Create, Read, Update, Delete) Operations
Insert new records into each table.
Read/display records from each table.
Update existing records in each table.
Delete records from each table.
Answer :
Word Count : 198
____ __________ __________ ________ _______ _______ _____ ____ _________ ________ ____.
________ ___ ______ ______ ________ __________ ____ _______ __________ ________.
____ _____ _________ _____ _______.
____ _______ ____ __________ __________ ____ _______ ________ ____ ______ ___ ______.
_____ ____ ___ _________ ____ ________ ______ _____ _____ _________ _______.
_____ _________ _____ ________ ______.
____ _____ ________ _________ _______ _________ __________ ________ ______ _______ ____ __________.
__________ _____ ______ ___ _________ ________ _______.
___ ___ _________ ______ _________ _________ ___ _________ ________ _____ ____ ___.
_________ ____ _____ ______ _______ _________ _________ ________ _________ _____ ____ ________.
__________ __________ ________ ___ ________ ______ ___ __________ ______ ___.
___ __________ ___ _________ __________ ___ ______.
___ _________ _____ _______ ____ _____ ____ ____ ____ ___ __________.
________.
Skip in 10
Create (Insert new records into each table): ```sql -- Insert into Students table INSERT INTO Students (StudentID, Name, Age, Department) VALUES (101, 'John Doe', 20, 'Computer Science'); -- Insert into Courses table INSERT INTO Courses (CourseID, CourseName, Credits) VALUES (201, 'Database Systems', 4); -- Insert into Enrollments table INSERT INTO Enrollments (EnrollmentID, StudentID, CourseID, Semester) VALUES (301, 101, 201, 'Fall 2025'); ``` Read
______ ____ ____ ____ _____ __________ ____ ____ _____.____ __________ __________ ________ _______ _______ _____ ____ _________ ________ ____.
________ ___ ______ ______ ________ __________ ____ _______ __________ ________.
____ _____ _________ _____ _______.
____ _______ ____ __________ __________ ____ _______ ________ ____ ______ ___ ______.
_____ ____ ___ _________ ____ ________ ______ _____ _____ _________ _______.
_____ _________ _____ ________ ______.
____ _____ ________ _________ _______ _________ __________ ________ ______ _______ ____ __________.
__________ _____ ______ ___ _________ ________ _______.
___ ___ _________ ______ _________ _________ ___ _________ ________ _____ ____ ___.
_________ ____ _____ ______ _______ _________ _________ ________ _________ _____ ____ ________.
__________ __________ ________ ___ ________ ______ ___ __________ ______ ___.
___ __________ ___ _________ __________ ___ ______.
___ _________ _____ _______ ____ _____ ____ ____ ____ ___ __________.
________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.