Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
-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.

-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.

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 40P
See similar textbooks
icon
Related questions
Question

Three do If including downvote so far as well incorrectly. 

  1. 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.

  2. Now write a command that will remove this student from the STUDENT table.

  3. How would your command look like if your task was to remove any student with the last name Lopez from the STUDENT table?

  4. 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.
Transcribed Image Text: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 in this 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 do not repeat across semesters. STUDENT (StudentID, StudentName) StudentID 38214 54907 66324 70542 Faculty D 2143 3467 4756 FACULTY (FacultyID, FacultyName) CourselD StudentName ISM 3113 ISM 3112 ISM 4212 ISM 4930 *** Letersky Altvater Aiken Marra COURSE (CourselD, CourseName) FacultyName Birkin Berndt Collins CourseName Syst Analysis Syst Design Database Networking QUALIFIED (FacultyID, CourselD, DateQualified) FacultyID 2143 2143 3467 3467 4756 4756 SectionNo 2712 2713 2714 2715 *** SECTION (SectionNo, Semester, CourselD) StudentID CourselD ISM 3112 ISM 3113 ISM 4212 ISM 4930 ISM 3113 ISM 3112 38214 54907 54907 66324 Semester 1-2018 1-2018 Il-2018 II-2018 SectionNo DateQualified REGISTRATION (StudentID, SectionNo) 2714 2714 2715 2713 9/2008 9/2008 9/2015 Figure 5-11 Class scheduling relations (missing ASSIGNMENT) 9/2016 9/2011 9/2011 CourselD ISM 3113 ISM 3113 ISM 4212 ISM 4930
Transcribed Image Text: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 in this 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 do not repeat across semesters. STUDENT (StudentID, StudentName) StudentID 38214 54907 66324 70542 Faculty D 2143 3467 4756 FACULTY (FacultyID, FacultyName) CourselD StudentName ISM 3113 ISM 3112 ISM 4212 ISM 4930 *** Letersky Altvater Aiken Marra COURSE (CourselD, CourseName) FacultyName Birkin Berndt Collins CourseName Syst Analysis Syst Design Database Networking QUALIFIED (FacultyID, CourselD, DateQualified) FacultyID 2143 2143 3467 3467 4756 4756 SectionNo 2712 2713 2714 2715 *** SECTION (SectionNo, Semester, CourselD) StudentID CourselD ISM 3112 ISM 3113 ISM 4212 ISM 4930 ISM 3113 ISM 3112 38214 54907 54907 66324 Semester 1-2018 1-2018 Il-2018 II-2018 SectionNo DateQualified REGISTRATION (StudentID, SectionNo) 2714 2714 2715 2713 9/2008 9/2008 9/2015 Figure 5-11 Class scheduling relations (missing ASSIGNMENT) 9/2016 9/2011 9/2011 CourselD ISM 3113 ISM 3113 ISM 4212 ISM 4930
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
SQL Functions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage
SEE MORE TEXTBOOKS