Person (Name, ID, Address, DOB) - Instructor (InstructorID, Rank, Salary) - Stud

Question

Person (Name, ID, Address, DOB)

- Instructor (InstructorID, Rank, Salary)

- Student (StudentID, Classification, GPA, MentorID, CreditHours)

-Course (CourseCode, CourseName, PreReq)

-Offering (CourseCode, SectionNo, InstructorID)

- Enrollment (CourseCode, SectionNo, StudentID, Grade)

Note:PreReq=Pre-Requirest

From the SQL tables commands above,use the English statement below the write SQL statements:

Delete the record for Jan Austin from the Person table. If she is a student or an instructor, you should do the deletion with usual care.

Explanation / Answer

this query deletes the entire data of jan antin in both in person table and student table.

this query deletes the row in both person and instructor table.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.