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 with AI-Powered 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