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.

Computer Networking: A Top-Down Approach (7th Edition)
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...
icon
Related questions
Question

Answer 3

5-39. Write SQL commands for the following:

  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

Blurred answer
Similar questions
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY