MySQLCreate the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter).Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME. OWNER_NUMLAST_NAMEFIRST_NAMEADDRESSCITYSTATEZIP_CODEAK102AksoyCeyda411 Griffin Rd.SeattleWA98131BI109BianchiNicole7990 Willow Dr.New YorkNY10005BU106BurkeErnest613 Old Pleasant St.Twin FallsID83303CO103ColeMeerab9486 Circle Ave.OlympiaWA98506J0110JonesAmmarah730 Military Ave.SeattleWA98126КО104KowalczykJakub7431 S. Bishop St.BellinghamWA98226LO108LopezJanine9856 Pumpkin Hill Ln.EverettWA98213МO100МooreElle-May8006 W. Newport Ave.RenoNV89508

We will need one input-output type parameter and two output type parameters for our procedure…

MySQL Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter). Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME

MySQL Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter). Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter8: Advanced Sql

Section: Chapter Questions

Problem 69C: Update the DETAILRENTAL table to set the values in DETAIL_RETURNDATE to include a time component....

See similar textbooks

Similar questions

CUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…
CUSTOMERColumns = 7, Rows = 10 CustomerID LastName FirstName Address ZIP Phone Email 1 Shire Robert 6225 Evanston Ave N 98103 206-524-2433 Robert.Shire@somewhere.com 2 Goodyear Katherine 7335 11th Ave NE 98105 206-524-3544 Katherine.Goodyear@somewhere.com 3 Bancroft Chris 12605 NE 6th Street 98005 425-635-9788 Chris.Bancroft@somewhere.com 4 Griffith John 335 Aloha Street 98109 206-524-4655 John.Griffith@somewhere.com 5 Tierney Doris 14510 NE 4th Street 98005 425-635-8677 Doris.Tierney@somewhere.com 6 Anderson Donna 1410 Hillcrest Parkway 98273 360-538-7566 Donna.Anderson@elsewhere.com 7 Svane Jack 3211 42nd Street 98115 206-524-5766 Jack.Svane@somewhere.com 8 Walsh Denesha 6712 24th Avenue NE 98053 425-635-7566 Denesha.Walsh@somewhere.com 9 Enquist Craig 534 15th Street 98225 360-538-6455 Craig.Enquist@elsewhere.com 10 Anderson Rose 6823 17th Ave NE 98105 206-524-6877 Rose.Anderson@elsewhere.com EMPLOYEEColumns = 5, Rows = 5 EmployeeID LastName FirstName…
SUPPLIER PRODUCT ProductCode ProductnName unitPrice SupCode supCode (Number, 3) SupName (text, 20) АВC LLC (Number, 10) [Char(10)] (>0) 1111111 Calculator 10 111 111 2222222 Notebook 2.5 777 222 ХҮX LLC 3333333 Book-AI 20 222 3333 PQR LLC 4444444 Pen -2.0 222 222 AXL LLC 5555555 Pencil .500 111 Eraser .500 222
Required information id fname lname company address city ST zip 103 Art Venere 8 W Cerritos Ave #54 Bridgeport NJ 8014 104 Lenna Paprocki Feltz Printing 639 Main St Anchorage AK 99501
Year Gender Name_of_person Date_of birth Membership _type Contact_phone_no joined Contact_email 2018 Nor Kwa 03 2453 5673 2/4/2005 n.kwa@rockict.com Social Adam Mazian 082 25 4689 2016 23/5/2003 Social AdamM@abc.co.my Ahmed Othman 12/03/2006 01223 432678 2018 Junior AOthman@cie.org Zara Png 1/12/1997 123 3267 9999 2010 F Senior Zara@cbc.cn
INVOICE VEND_ QUANT_ PROD_ INV_NUM PROD_NUM SALE_DATE PROD_LABEL VEND_NAME CODE SOLD PRICE 211347 AA-E3422QW 15-JAN-2016 Rotary sander 211 Neverfail, Inc. 1 $49.95 211347 QD-300932X 15-JAN-2016 0.25-in. drill bit 211 Neverfail, Inc. 8 $3.45 211347 RU-995748G 15-JAN-2016 Band saw 309 BeGood, Inc. 1 $39.99 211348 AA-E3422QW 15-JAN-2016 Rotary sander 211 Neverfail, Inc. $49.95 211349 GH-778345P 16-JAN-2016 Power drill 157 ToughGo, Inc. 1 $87.75
SLSREP_FNAME SLSREP_INITIAL SLSREP_EMAIL CUSTOMER PK CUST NUM CUST_LNAME CUST_FNAME CUST_AREACODE CUST_PHONE CUST_E-MAIL CUST_SHIP_ADDRESS CUST_SHIP_CITY CUST_SHIP_STATE CUST_ZIP_CODE PK,FK1 PK FK2 HE SALESREP INVOICE PK SLSREP NUM PK INV_NUM SLSREP_LNAME-It writes OFK1 CUST_NUM FK2 SLSREP_NUM INV_DATE INV_SUBTOTAL I generates INV_TAX INV_TOTAL contains INV_LINE INV_NUM INV_LINE_NUM PROD_CODE INV_LINE_PRICE INV_LINE_QUANT INV_LINE_TOTAL VENDOR PK VEND_CODE VEND_NAME VEND_CONTACT VEND_EMAIL I supplies PRODUCT PK PROD_CODE is written in +1-FK1 VEND_CODE PROD_DESCRIPTION PROD_PRICE PROD_QOH
INVOICES INVOICE LINE INVOICE NUM INVOICE DATE CUST ID 11/15/2021 INVOICE NUM ITEM ID QUANTITY 14216 QUOTED PRICE 14216 125 CA75 $37.99 14219 11/15/2021 227 14219 AD72 $79.99 14222 11/16/2021 294 14219 DT12 4. $39.99 14224 11/16/2021 182 14222 LD14 $47.99 14228 11/18/2021 435 14224 KH81 4. $18.99 14231 14233 14237 11/18/2021 11/18/2021 125 14228 FS42 $124.99 435 14228 PF19 1. $74.99 11/19/2021 616 14231 UF39 2. S189.99 14233 KH81 $19.99 QB92 WB49 LP73 14233 $109.95 14233 $74.95 14237 $54.95 ТЕМ ITEM ID DESCRIPTION ON HAND CATEGORY LOCATION PRICE Dog Feeding Station Fenthers Bird Cage (12x24x18) AD72 12 DOG B. $79.99 10 BRD B $79.99 CA75 Enclosed Cat Litter Station 15 CAT $39.99 Dog Toy Gift Set Fly Mask with FRars Folding Saddle Stand Aquarium (55 Gallon) DT12 27 DOG B $39.99 FM23 41 HOR $24.95 FS39 12 HOR $39.99 FS42 FSH A. $124.99 KHS1 LD14 Wild Bird Food (25 Ib) 24 BRD $19.99 Locking Small Dog Door 14 DOG $49.99 LP73 Lange Pot Carrier 23 DOG $59.99 Pump & Filter Kit Quilted Stable…
Member ID 1582 2587 3549 9536 2567 2154 3265 8765 3259 6540 First Name Mara Philip Kathleen Sau Shanice Chase Tommie Dorcas Angel Weston BookingID 1 2 3 4 5 6 7 8 Table 1: Member Last Name Gender Age Female 25 Male 36 Female 25 United States Female 25 United States Hashimoto Gent Hanner Pfau Mccrystal Karner Jia Darity Sanor Martina Room Room 15 Room 25 Room 1 Room 15 Room 5 Room 21 Room 3 Room 8 Date 29-Dec-2020 9-Dec-2021 3-Mar-2019 4-Sep-2021 13-Feb-2021 6-May-2021 10-Nov-2020 4-Apr-2022 Table 2: Booking Days 2 4 6 5 10 6 5 Female 36 Male 37 Male 26 Female 37 Male 24 Male 23 4 Table 3: Make MemberID 3549 9536 6540 2154 2567 2154 3265 1582 $150.00 $80.00 $120.00 $300.00 Country Uganda France 3 4 China Australia United States United States Cost per day $200.00 $80.00 $80.00 $150.00 5 6 7 8 France China BookingID 1 2 Joined Date 16-Aug-2020 21-May-2015 12-Dec-2017 16-Aug-2019 16-Aug-2020 1-Jan-2021 29-Dec-2018 21-May-2019 4-Mar-2019 1-Feb-2022 Status Paid Paid Pending Paid Pending Paid…
Estem.org/courses/64525/assignments/9460783?module_item_id=18078917 The following information can help you get started: • Invitation Details: it boils down to when and where o When: Time and date • Where: Address • Invitee List: Name and email • Name: First Name, or First Name and Last Name Email: Email address . Other considerations: After you complete your invitation, answer the following questions: 1. What type of data are time, date, and place? How are they different from the other data types on the invite and guest list? F4 A Additional information worth including: dress code, directions, gifting, how to contact you. . How will you know who is showing up? RSVP? . Is there a theme to your invitation/design? x F5 % F6 F7 DELL F8 F9 ROMNA F10 F11 PrtScr
Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.
PK Cus CODE PK INV NUMBER PK,FK1 INV NUMBER LINE NUMBER HEDenerates contains PK CUS LNAME CUs FNAME CUs INITIAL CUS AREACODE CUS PHONE CUS BALANCE FK1 CUS CODE INV DATE P CODE LINE UNITS LINE PRICE FK2 is found in VENDOR PRODUCT PK V CODE PK P CODE V NAME v CONTACT V AREACODE V PHONE V_STATE V ORDER P DESCRIPT P INDATE P_QOH P MIN P PRICE DISCOUNT FK1 V CODE upplies Write a SQL query to list the product code, vendor code, and vendor name for all products and includes those vendors with no matching products. Y CODE- PRODUCTY CODE