Homework Help Question & Answers

Using MYSQL please help (#7){Screen shot} Write a script that removes the view, the two tables, and the database, with one click of the execute button. In the screen shot, display all the SQL code, an...

Using MYSQL please help

(#7){Screen shot} Write a script that removes the view, the two tables, and the database, with one click of the execute button. In the screen shot, display all the SQL code, and show the Object Explorer after the script executes.

Category CID Description Product PID Description CID (fk) Cost SalePrice AvailableOnline (Y, N)

  • Add records to the Category table and the Products table. One screenshot should show the SQL code and the output of a SELECT statement showing the records in the table (two screenshots, one for each table) :
    1. Insert 3 rows in the Category table:
      1. Bicycles
      2. Components
      3. Accessories
    2. Insert the following records into the Product table:
      1. Schwinn Beach Cruiser, Bicycles category, $79.99, $159.99, N
      2. Diamondback Mountain Bike , Bicycles category, $1,449.99, $2,799.99, N
      3. Cannondale Touring Bicycle, Biclcyes category, $299.00, $625.00, N
      4. Shimano Disc Brake, Components category, $69.89, $149.99, Y
      5. Shimano Derailleur, Components category, $117.88, $229.99, Y
      6. Nitto Mustache Alloy Bar, Components category, $74.99, $94.99, N
      7. Crank Brothers Gem Pump, Accessories category, $12.79, $19.99, Y
      8. Shimano Pro Torque Wrench, Accessories category, $57.99, $139.99, Y
      9. Thule Passage 2 Trunk Rack, Accessories category, $126.95, $149.95, N
Category CID Description Product PID Description CID (fk) Cost SalePrice AvailableOnline (Y, N)
0 0
Next > < Previous
ReportAnswer #1

Solution:

I have MySQL workbench.

It wil even work with command prompt.

MySQl Workbench Local instance MySQL80 × File Edit View Query Database Server Tools Scripting Help Navigator ucry HFTAOSILimiMySQl Workbench Local instance MySQL80 × File Edit View Query Database Server Tools Scripting Help Query 1 x Navigator SCHEMAMySQl Workbench Local instance MySQL80 x File Edit View Query Database Server Tools Scripting Help Navigator SCHEMAS Jump toMySQl Workbench Local instance MySQL80 × File Edit View Query Database Server Tools Scripting Help Navigator ucry SCHEMAS Lim

Know the answer?
Add Answer of:
Using MYSQL please help (#7){Screen shot} Write a script that removes the view, the two tables, and the database, with one click of the execute button. In the screen shot, display all the SQL code, an...
Your Answer: Your Name: What's your source?
Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
Need Online Homework Help?
Ask a Question
Get FREE Expert Answers
WITHIN MINUTES