Question

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

Answer 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 HFTAOSILimit to 1000 rowsQ1 SCHEMAS ump to objects first sakila sYS world 1Create database second Automatic context help is disabled. Use the toolbar to manually get help for the current caret position or to toggle automatic help 2use secondj 3 create table category( CID int not null, 5 description varchar(180) not null, 6 primary key (CID) р. 8 create table product( PID int not nul1, 18 description varchar (180) not nul1, CID int not nul1, 12 cost varchar (10) not null, 13 14 available varchar(10) not null, 15 16 foreign key (CID) references category (CID) 17)i 18insert into category values(1, Bicycles') 19insert into category values(2, Components') 2insert into category valus(3 "Accessories') 21select from category 22insert into product values(1, Schwinn Beach Cruiser79.99$159.99,N') saleprice varchar (18) not null, Administration Schemas primary key(PID), No object selected

MySQl Workbench Local instance MySQL80 × File Edit View Query Database Server Tools Scripting Help Query 1 x Navigator SCHEMAS Limit to 1000 rows ump to objects first sakila sYS world CID int not null, cost varchar (10) not nul1, saleprice varchar(10) not null, available varchar (18) not null, Automatic context help is disabled. Use the toolbar to manually get help for the current caret position or to toggle automatic help. 15 primary key (PID) 16 foreign key(CID) references category (CID) 18 İnsert into category values(1, 'Bicycles'); 19insert into category values (2, Components') 20insert into 21select from category 22insert into product values (1, Schwinn Beach Cruiser'1, $79.99', $159.99 "N) 23insert into product values (2, "Diamondback Mountain Bike'1, $1,449.99' $2,799.99''N') 24insert into product values (3, "Cannondale Touring Bicycle,1, $299.80 $625.88', N') 25insert into product values(4, Shimano Disc Brake, 2, $69.89$149.99',Y); 26 ● insert into product values(5," Shimano Derailleur., 2, .$117.88., .$229.99", ·Y'); 27insert into product values (6, "Nitto Mustache Alloy Bar, 2, $74.99 $94.99N)s 28 insert into product values(7,'Crank Brothers Gem Pump", 3, '$12.79', '$19.99', 'Y')i 29 İnsert into product values(8, "Shimano Pro Torque lirench, ,3, ,$57.99", ,$139.99', 'Y'); 3insert into product values(9, Thule Passage 2 Trunk Rack', 3, $126.95 $149.95 N) 31select from product; category values (3 Accessories' Administration Schemas No object selected Context Help Snippets

MySQl Workbench Local instance MySQL80 x File Edit View Query Database Server Tools Scripting Help Navigator SCHEMAS Jump to objects foreign key (CID) references category(CID) 16 17)5 18insert into category values(, Bicycles) 19insert into category values(2, Components') 20insert into category valus(3, "Accessories')5 21selectfrom category Automatic context help is disabled. Use the toolbar to manually get help for the current caret position or to toggle automatic help first sakila sys world | Result Grid!韮t、Fier Rows: | Edit: 떠 ヨ島1 Export/Import:轴验 Wrap Cel Content: CID desaription 1Bicycles Resut Grid Administration Schemas category 8 x Revert Context Help Snippets

MySQl Workbench Local instance MySQL80 × File Edit View Query Database Server Tools Scripting Help Navigator ucry SCHEMAS Limit to 1000 rows ump to objects 23 . insert into product values(2,'Diamondback Mountain Bike' ,1, .$1,449.99", .$2,799.99", ·N); 24 ● insert into product values(3,'Cannondale Touring Bicycle' ,1, '$299.09", "S625.00', 'N'); 25 . insert into product values(4, 'Shimano Disc Brake', 2,'$69.89','$149.99", "Y"); 26 . insert into product values(5,"Shimano Derailleur', 2, .$117.88', '$229.99", 'Y'); 27insert into product values (6, Nitto Mustache Alloy Bar $74.99$94.99,'N) 28 . insert into product values(7, "Crank Brothers Gem Pump., 3, .$12.79", "$19.99", ·Y'); 29insert into product values (8, Shimano Pro Torque Wrench',3, $57.99 $139.99', 'Y' 30 insert into product values(9,'Thule Passage 2 Trunk Rack', 3, .$126.95', '$149.95', 'N'); 31select from productj 32 Automatic context help is disabled. Use the toolbar to manually get help for the current caret position or to toggle automatic help first ▶ sakila sYS world р. Result GridFiter Rows ER: 떠劻區1 Exportim port:轴粉1 wrap Cel Content:区 PID description 1Schwinn Beach Cruiser 2 Diamondback Mountain Bike $1,449.99 $2,799.99 N 3 Cannondale Touring Bicyde 1 $299.00 $625.00 N 4 Shimano Disc Brake saleprice available CID Cost Administration Schemas 1$79.99$159.99 N Grid 2 $69.89 $149.99Y 117.88 $229.99 Y 2 $74.99$94.99 N No object selected Form Editor Shimano Deralleur 6 Nitto Mustache Alloy Bar 7 Crank Brothers Gem Pump 3 $12.79 $19.99Y 8 Shimano Pro Torque Wrench 3 $57.99 $139.99 Y 9 Thule Passage 2 Trunk Rack 3 $126.95 $149.95 N *四四 product 9 x Revert Context Help Snippets Output