Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MySQL using MySQL work bench and MAMP 1*3. Create a function that accepts an itemId as input and returns the number of items in stock.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedMySQL using MySQL work bench and MAMP

1*3. Create a function that accepts an itemId as input and returns the number of items in stock. Paste the create function SQL below. uservehide user vehideld INT (11) userId VARCHAR(50) vehidet INT (11) Users vehicle vehideld INT (11) omake VARCHAR(255) model VARCHAR(255) year INT(11) cylinders INT (11) displacement VARCHAR(255) drive VARCHAR (255) engid INT(11) eng_dser VARCHAR(255) trany VARCHAR(255) Ompohighway VARCHAR(255) mpgcity VARCHAR(255) fue CostAnnual INT (11) fueType VARCHAR(255) fuel Type I VARCHAR(255) ovas VARCHAR(255) occupation occupation d INT (11) occupation VAROHAR (250) userid VAROLAR (50) frstrane VARCHAR(100) lastname VARCHAR(100) middleName VARCHAR(100) username VARCHAR(20) password VARCHAR (20) dob DATE gender CHAR(1) OccupationId INT (11) userStatusid INT (11) userTypeId INT(11) created DATETIME Indexes item itemid INT (11) itemName VARCHAR(100) itemPrice DECIMA (10,2) primarydmage VARCHAR(50) item Category VARCHAR(50) Idees userdvd user Dvdid INT(11) userid VARCHAR(50) dveld INT(11) dvd dveld INT(11) DVD Tie VAROLAR(255) Studio VARCHAR(255) Released VARCHAR(255) Status VARCHAR(255) Sound VAROHAR(255) Versions VARCHAR(255) Price VAROHAR (255) OR Rating VARCHAR(255) Year VARCHAR(255) Genre VARCHAR(255) Aspect VARCHAR(255) UPC VARCHAR(255) DVD Release Date VARCHAR(255) createdDate VARCHAR(255) publicating DECIMAL (42) Indexes orderitem orderd INT(11) Oteld INT (11) quantity INT (11) orders orderid INT(11) used VARCHAR(50) orderDate DATETIME shipping DATETIME Result Grid orderId 1 itemId Filter Rows: quantity 2 40 wwwwwwN orderitem 1 x Result Grid itemId Filter Rows: Edit: 3 itemName itemPrice Billabong Men Striper Long Sleeve Woven Shirt 39.99 Wrangler Men Rugged Wear Relaxed Fit Jeans 18.88 Columbia Men's Steens Mountain Full Zip 2.0 Fle... 45.98 Apple? - MacBook Air - 13.3* Display - 4GB Mem... 975.99 Samsung - 60* Class (60 Diag.) - LED - 1080p - ... 1099.99 Call of Duty: Ghosts - Xbox 360 59.99 Brother - Network Ready Wireless Black-and-w... 119.99 HP-LaserJet Pro M451dn Network Ready Color... 399.99 Black Thick Slouchy Knit Oversized Beanie Cap Hat 13.99 Mini Cooper Logo Tire Valve Caps with Wrench ... 15.99 Hamilton Beach Personal Blender 13.49 Marvel Universe Titan Hero Series Super Hero C... 49.99 Export/Import: Wrap Cell Content: A primaryImage itemCategory_ quantityInStock billa4.jpg Clothing 10 wrjeanb.jpg Clothing 10 col334222.jpg Clothing a ppuytte667.jpg Computers sii88u53.jpb Electronics cod 7766.jpg Games spoo99.jpg Printers dsk987868.jpg Printers f dgj54398.jpg Clothing fddfsd877.jpg Automotive fdsf888.jpg Kitchen fdgj7781.jpg Toys 12

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases And Python Programming MySQL MongoDB OOP And Tkinter

Authors: R. PANNEERSELVAM

1st Edition

9357011331, 978-9357011334

More Books

Students also viewed these Databases questions

Question

List the benefits of depositary receipts to the investors.

Answered: 1 week ago

Question

Define Scientific Management

Answered: 1 week ago

Question

Explain budgetary Control

Answered: 1 week ago

Question

Solve the integral:

Answered: 1 week ago

Question

What is meant by Non-programmed decision?

Answered: 1 week ago

Question

=+ What does the usage of these products abroad look like?

Answered: 1 week ago