Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
In these exercises, you'll use MYSQL Workbench to review the tables in the AP database. In addition, you'll use MYSQL Workbench to enter SQL statements and run them against these tables. Make sure the MySQL server is running 1. Start MYSQL Workbench and open a connection for the root user. 2. Check whether the MYSQL server is running. If it isn't, start it. When you're done, close the Startup/Shutdown window. Use MYSQL Workbench to review the Accounts Payable (AP) database 3. In the Navigator window, expand the node for the AP database so you can see all of the database objects it contains. 4. View the data for the Vendors and Invoices tables. Chapter 2 How to use MYSQL Workbench and other development tools 71 5. Navigate through the database objects and view the column definitions for at least the Vendors and Invoices tables. Use MYSQL Workbench to enter and run SQL statements 6. Double-click the AP database to select it. When you do that, MYSQL Workbench should display the database in bold. 7. Open a SQL Editor tab. Then, enter and run this SQL statement: SELECT vendor_name FROM vendors 8. Delete the e at the end of vendor_name and run the statement again. Note the error number and the description of the error. 9. Open another SQL Editor tab. Then, enter and run this statement: SELECT COUNT(") AS number_of_invoices, SUM(invoice_total) AS grand_invoice_total FROM invoices Use MYSQL Workbench to open and run scripts 10. Open the select_vendor_city_state script that's in the

In these exercises, you'll use MYSQL Workbench to review the tables in the AP database. In addition, you'll use MYSQL Workbench to enter SQL statements and run them against these tables. Make sure the MySQL server is running 1. Start MYSQL Workbench and open a connection for the root user. 2. Check whether the MYSQL server is running. If it isn't, start it. When you're done, close the Startup/Shutdown window. Use MYSQL Workbench to review the Accounts Payable (AP) database 3. In the Navigator window, expand the node for the AP database so you can see all of the database objects it contains. 4. View the data for the Vendors and Invoices tables. Chapter 2 How to use MYSQL Workbench and other development tools 71 5. Navigate through the database objects and view the column definitions for at least the Vendors and Invoices tables. Use MYSQL Workbench to enter and run SQL statements 6. Double-click the AP database to select it. When you do that, MYSQL Workbench should display the database in bold. 7. Open a SQL Editor tab. Then, enter and run this SQL statement: SELECT vendor_name FROM vendors 8. Delete the e at the end of vendor_name and run the statement again. Note the error number and the description of the error. 9. Open another SQL Editor tab. Then, enter and run this statement: SELECT COUNT(") AS number_of_invoices, SUM(invoice_total) AS grand_invoice_total FROM invoices Use MYSQL Workbench to open and run scripts 10. Open the select_vendor_city_state script that's in the

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question
100%

Don't copy paste frm other sources if u know 100% thn answer i will up vote

Else I will Downvote

Sub:- Database

 

In these exercises, you'll use MYSQL Workbench to review the tables in the AP database. In addition, you'll use MYSQL Workbench to enter SQL statements and run them against these tables. Make sure the MYSQL server is running 1. Start MYSQL Workbench and open a connection for the root user. 2. Check whether the MYSQL server is running. If it isn't, start it. When you're done, close the Startup/Shutdown window. Use MYSQL Workbench to review the Accounts Payable (AP) database 3. In the Navigator window, expand the node for the AP database so you can see all of the database objects it contains. 4. View the data for the Vendors and Invoices tables. Chapter 2 How to use MYSQL Workbench and other development tools 715. Navigate through the database objects and view the column definitions for at least the Vendors and Invoices tables. Use MYSQL Workbench to enter and run SQL statements 6. Double-click the AP database to select it. When you do that, MYSQL Workbench should display the database in bold. 7. Open a SQL Editor tab. Then, enter and run this SQL statement: SELECT vendor_name FROM vendors 8. Delete the e at the end of vendor_name and run the statement again. Note the error number and the description of the error. 9. Open another SQL Editor tab. Then, enter and run this statement: SELECT COUNT(") AS number_of_invoices, SUM(invoice_total) AS grand_invoice_total FROM invoices Use MYSQL Workbench to open and run scripts 10. Open the select_vendor_city_state script that's in the c\murach\mysql\scripts\ch02 directory. Note that this script contains just one SQL statement. Then, run the statement. 11. Open the select_vendor_total_due script that's in the ch02 directory. Note that this opens another SQL Editor tab. 12. Open the select_vendor_information script that's in the ch02 directory. Notice that this script contains two SQL statements that end with semicolons (scroll down if you need to). 13. Press the Ctrl-Shift+Enter keys or click the Execute SQL Script button to run both of the statements in this script. Note that this displays the results in two Result grids. Make sure to view the results of both SELECT statements. 14. Move the insertion point into the first statement and press Ctrl-Enter to run just that statement. 15. Move the insertion point into the second statement and press Ctrl+Enter to run just that statement. 16. Exit from MYSQL Workbench.
Transcribed Image Text:In these exercises, you'll use MYSQL Workbench to review the tables in the AP database. In addition, you'll use MYSQL Workbench to enter SQL statements and run them against these tables. Make sure the MYSQL server is running 1. Start MYSQL Workbench and open a connection for the root user. 2. Check whether the MYSQL server is running. If it isn't, start it. When you're done, close the Startup/Shutdown window. Use MYSQL Workbench to review the Accounts Payable (AP) database 3. In the Navigator window, expand the node for the AP database so you can see all of the database objects it contains. 4. View the data for the Vendors and Invoices tables. Chapter 2 How to use MYSQL Workbench and other development tools 715. Navigate through the database objects and view the column definitions for at least the Vendors and Invoices tables. Use MYSQL Workbench to enter and run SQL statements 6. Double-click the AP database to select it. When you do that, MYSQL Workbench should display the database in bold. 7. Open a SQL Editor tab. Then, enter and run this SQL statement: SELECT vendor_name FROM vendors 8. Delete the e at the end of vendor_name and run the statement again. Note the error number and the description of the error. 9. Open another SQL Editor tab. Then, enter and run this statement: SELECT COUNT(") AS number_of_invoices, SUM(invoice_total) AS grand_invoice_total FROM invoices Use MYSQL Workbench to open and run scripts 10. Open the select_vendor_city_state script that's in the c\murach\mysql\scripts\ch02 directory. Note that this script contains just one SQL statement. Then, run the statement. 11. Open the select_vendor_total_due script that's in the ch02 directory. Note that this opens another SQL Editor tab. 12. Open the select_vendor_information script that's in the ch02 directory. Notice that this script contains two SQL statements that end with semicolons (scroll down if you need to). 13. Press the Ctrl-Shift+Enter keys or click the Execute SQL Script button to run both of the statements in this script. Note that this displays the results in two Result grids. Make sure to view the results of both SELECT statements. 14. Move the insertion point into the first statement and press Ctrl-Enter to run just that statement. 15. Move the insertion point into the second statement and press Ctrl+Enter to run just that statement. 16. Exit from MYSQL Workbench.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Database Functions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS