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..
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..
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 2.9CP
Related questions
Question
Do three please any
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..
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd8fc712a-b186-461b-8637-04cb5448ab14%2F8b9210f3-d5ab-4daa-9692-3c8da2283ea0%2Fycwihvt_processed.jpeg&w=3840&q=75)
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
![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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd8fc712a-b186-461b-8637-04cb5448ab14%2F8b9210f3-d5ab-4daa-9692-3c8da2283ea0%2F41zzhsq_processed.jpeg&w=3840&q=75)
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.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
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
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr