In the table above, Vanesa’s last name was omitted. Write an SQL query to add the last name. Assume the last name is ‘Johnson’

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

2.1 In the table above, Vanesa’s last name was omitted. Write an SQL query to add the last
name. Assume the last name is ‘Johnson’

2.2 John Silas is an employee in a Logistics company with ID = 02361. He was newly promoted
with an increase of R2000 on his salary. Write an SQL query to update his record in the
stafflist table

2.3 An alias provides a mechanism to rename a column or an expression. Under what
conditions should you enclose an alias in double quotes?

Consider the following table
Table 1: studentlist
Snum
00001
00002
00003
00004
00005
00006
00007
00011
00022
00033
First_name
Nkosi
Samson
James
Khetha
Evelyn
Mercy
Paul
Jean
Peter
Vanesa
Last_name
Zanele
Ocholi
Stone
Dludla
Taylor
Andrew
Mandla
Zille
Abe
Department
Marketing
IT
Accounting
Surveying
Statistics
History
Mathematics
Chemistry
IT
Accounting
Year Admission
2018
2019
2018
2021
2020
2019
2021
2022
2022
2022
Transcribed Image Text:Consider the following table Table 1: studentlist Snum 00001 00002 00003 00004 00005 00006 00007 00011 00022 00033 First_name Nkosi Samson James Khetha Evelyn Mercy Paul Jean Peter Vanesa Last_name Zanele Ocholi Stone Dludla Taylor Andrew Mandla Zille Abe Department Marketing IT Accounting Surveying Statistics History Mathematics Chemistry IT Accounting Year Admission 2018 2019 2018 2021 2020 2019 2021 2022 2022 2022
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Multiple table
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education