Answer 35-39. Write SQL commands for the following:Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the STUDENT table.Now write a command that will remove this student from the STUDENT table.How would your command look like if your task was to remove any student with the last name Lopez from the STUDENT table?Create an SQL command that will modify the name of course ISM 4212 from Database to Introduction to Relational Databases.. 5-39. Write SQL commands for the following:a. Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the STUDENT table.b. Now write a command that will remove this student from the STUDENT table.c. How would your command look like if your task was to remove any student with the last name Lopez from the STUDENT table?d. Create an SQL command that will modify the name of course ISM 4212 from Database to Introduction to Relational Databases. Problems and Exercises 5-34 through 5-45 are based on the class scheduling 3NF relations along with some sample data shown in Figure 5-11 . Not shown inthis figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections. Note that values of the SectionNo column donot repeat across semesters.STUDENT (StudentID, StudentName)StudentID38214549076632470542Faculty D214334674756FACULTY (FacultyID, FacultyName)CourselDStudentNameISM 3113ISM 3112ISM 4212ISM 4930***LeterskyAltvaterAikenMarraCOURSE (CourselD, CourseName)FacultyNameBirkinBerndtCollinsCourseNameSyst AnalysisSyst DesignDatabaseNetworkingQUALIFIED (FacultyID, CourselD, DateQualified)FacultyID214321433467346747564756SectionNo2712271327142715***SECTION (SectionNo, Semester, CourselD)StudentIDCourselDISM 3112ISM 3113ISM 4212ISM 4930ISM 3113ISM 311238214549075490766324Semester1-20181-2018Il-2018II-2018SectionNoDateQualifiedREGISTRATION (StudentID, SectionNo)27142714271527139/20089/20089/2015Figure 5-11 Class scheduling relations (missing ASSIGNMENT)9/20169/20119/2011CourselDISM 3113ISM 3113ISM 4212ISM 4930

The SQL query to all the 4 questions are given below

Answered: Create two different forms of the…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Answer 3

5-39. Write SQL commands for the following:

Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the STUDENT table.
Now write a command that will remove this student from the STUDENT table.
How would your command look like if your task was to remove any student with the last name Lopez from the STUDENT table?
Create an SQL command that will modify the name of course ISM 4212 from Database to Introduction to Relational Databases.