● Write a simple stored function that • Takes a gender as an input • Find the staff whose gender matches the input • Return the results • Write a simple stored procedure that Takes a gender as an input Find the staff whose gender matches the input • Print the results

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
• Write a simple stored function that
Takes a gender as an input
●
Find the staff whose gender matches the input
Return the results
Write a simple stored procedure that
Takes a gender as an input
Find the staff whose gender matches the input
• Print the results
Transcribed Image Text:• Write a simple stored function that Takes a gender as an input ● Find the staff whose gender matches the input Return the results Write a simple stored procedure that Takes a gender as an input Find the staff whose gender matches the input • Print the results
[MariaDB [dreamhome]> Select * from Staff;
| staffNo fName | 1Name | position | sex
| SA9
Mary
Howe
Ford
David
| Assistant | F
Supervisor | M
Assistant | F
Ann
Beech
Susan Brand
F
White
| M
Lee
F
SG14
SG37
SG5
| SL21
SL41
John
Julie
Manager
Manager
Assistant
| DOB
|
branchNo |
| salary
1970-02-19 | 9500.00 | B007
1958-03-24 | 18000.00
1960-11-10 | 12000.00
B003
B003
1940-06-03 | 24000.00
B003
| 1945-10-01 | 30000.00 B005
1965-06-13 | 9000.00 B005
Transcribed Image Text:[MariaDB [dreamhome]> Select * from Staff; | staffNo fName | 1Name | position | sex | SA9 Mary Howe Ford David | Assistant | F Supervisor | M Assistant | F Ann Beech Susan Brand F White | M Lee F SG14 SG37 SG5 | SL21 SL41 John Julie Manager Manager Assistant | DOB | branchNo | | salary 1970-02-19 | 9500.00 | B007 1958-03-24 | 18000.00 1960-11-10 | 12000.00 B003 B003 1940-06-03 | 24000.00 B003 | 1945-10-01 | 30000.00 B005 1965-06-13 | 9000.00 B005
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Concept of memory addresses in pointers
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