Computers and Technology, 21.09.2020 23:01 brittany7436

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 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.

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 22:30

Which of the following factors would your hypothetical supervisor look at when deciding whether to test a biological material sample for dna? the amount of other evidence you have implicating a suspect in a crime the annual budget for the crime lab both of the above none of the above; you would almost always order a test

Answers: 3

Answer

Computers and Technology, 24.06.2019 03:40

4. does the kernel phenotype distribution support the idea that the cob is the result of a dihybrid cross? what information supports your answer? if a dihybrid cross (i.e. f1 to f2 of standard mendelian crosses) is not indicated what conditions might contribute to this finding.

Answers: 2

Answer

Computers and Technology, 24.06.2019 12:50

What percentage of teens plays video games? a.97% b.100% c.74% d.50%

Answers: 1

Answer

Computers and Technology, 24.06.2019 17:00

Anew author is in the process of negotiating a contract for a new romance novel. the publisher is offering three options. in the first option, the author is paid $5,000 upon delivery of the final manuscript and $20,000 when the novel is published. in the second option, the author is paid 12.5% of the net price of the novel for each copy of the novel sold. in the third option, the author is paid 10% of the net price for the first 4,000 copies sold, and 14% of the net price for the copies sold over 4,000. the author has some idea about the number of copies that will be sold and would like to have an estimate of the royal- ties generated under each option. write a program that prompts the author to enter the net price of each copy of the novel and the estimated number of copies that will be sold. the program then outputs he royalties under each option and the best option the author could choose. (use appropriate named constants to store the special values such as royalty rates and fixed royalties.

Answers: 1

Answer

You know the right answer?

In these exercises, you’ll use MySQL Workbench to review the tables in the AP database. In addition,...

Questions