Database computer science

Part $3$ CRUD Operations

Create $1$ tSQL script file and include the following CRUD statements. Call it Assignment$3\_$CRUD.sql$.$ Don$$t forget about the comments block from Part $1$

RAISERROR $($N$\text{'}$Question $\%$s for CRUD Operations', $--$ Message text.

$10,--$ Severity,

$1,--$ State,

$\text{'}$Q$1\text{'},--$First Argument

NULL, $--$ Second Argument

NULL$)$; $--$ third argument.

Create Statements

Q$1.$ Provide an insert statement to add a new student with these attributes

$$ StudentID $101$

$$ StudentName $$ John Doe

$$ Major $$ Computer Science

Q$2.$ Provide an insert statement to add a new course & instructor with these attributes

$$ InstructorID $102$

$$ InstrctuorName $$ Jane Doe

$$ InstructorLocation $$ Old Main

$$ CourseNum $505$

$$ CourseName $$ Test CourseName

Q$3.$ Provide an insert statement to enroll a student in course with these attributes

$$ StudentID $101$

$$ InstructorID $--102$

Winter $2024$ Introduction to Databases

$$ CourseNum $505$

$$ Grade $$ A

Q$4.$ Create a grade report for this student

Update Statements

Q$5.$ Provide an update statement to update InstructorName to $$Janet Doe$$

Q$6.$ Provide an update statement to update Student Major to $$Engineering$$

Q$7.$ Create a grade report for this student. Replicate the script from Q$4.$

DELETE Statements

Q$8.$ Create a grade report for all students in this database

Q$9.$ Pick one of your test data students and provide a delete statement

Q$10.$ Create a grade report for all students in this database replicate from Q$8$