a guide to mysql ch 7 Essay - 1277 Words

CIS 331 – Database Management Using SQL Week 6 Homework - Due: Week 7 Name  ¬Ã‚ ¬Ã‚ ¬ 1. Review Questions – page 207 (A Guide to MySQL – Chapter 7) Questions 1 - 19 (type out the answers) 2. Premier Products – pages 207 - 209 (A Guide to MySQL – Chapter 7) Exercises 1 – 9 (create in MySQL) Except where indicated, use MySQL Query Browser to perform each operation and print the results. 3. Henry Books – pages 209 (A Guide to MySQL – Chapter 7) Exercises 1 – 9 (create in MySQL) Except where indicated, use MySQL Query Browser to perform each operation and print the results. Estimated Completion Time: ___________ Comments: _______________________________ Lab Assignment Grade:†¦show more content†¦NUM = ORDER_LINE.ORDER_NUM AND PRICE 100; +----------+----------------+-----------+--------------+ | PART_NUM | DESCRIPTION | ORDER_NUM | QUOTED_PRICE | +----------+----------------+-----------+--------------+ | DR93 | Gas Range | 21610 | 495.00 | | DW11 | Washer | 21610 | 399.99 | | KL62 | Dryer | 21613 | 329.95 | | KT03 | Dishwasher | 21614 | 595.00 | | BV06 | Home Gym | 21617 | 794.95 | | CD52 | Microwave Oven | 21617 | 150.00 | | DR93 | Gas Range | 21619 | 495.00 | | KV29 | Treadmill | 21623 | 1290.00 | +----------+----------------+-----------+--------------+ 8 rows in set (0.00 sec) mysql CREATE VIEW ORDER_TOTAL AS - SELECT ORDERS.ORDER_NUM, SUM(NUM_ORDERED * QUOTED_PRICE) AS TOTAL_AMOUNT FROM ORDERS, ORDER_LINE WHERE ORDERS.ORDER_NUM = ORDER_LINE.ORDER_NUM GROUP BY ORDERS.ORDER_NUM - ORDER BY ORDER_NUM; Query OK, 0 rows affected (0.00 sec) mysql SELECT ORDER_NUM, TOTAL_AMOUNT FROM ORDER_TOTAL WHERE TOTAL_AMOUNT 1000; +-----------+--------------+ | ORDER_NUM | TOTAL_AMOUNT | +-----------+--------------+ | 21613 | 1319.80 | | 21614 | 1190.00 | | 21617 | 1589.90 | | 21623 | 2580.00 | +-----------+--------------+ 4 rows in set (0.00 sec) mysql SELECT ORDERS.ORDER_NUM, SUM(NUM_ORDERED * QUOTED_PRICE) AS T.TOTAL_AMOUNT FROMShow MoreRelatedNet Sec Essay11858 Words   |  48 Pagesaddresses Quick Scan- Provides a fast scan limiting the number of TCP ports scanned only the top 100 most common TCP ports Regular Scan-This is the default scan by issuing TCP SYN scans for the most common 1000 TCP ports using pings for host detection. 7. How many different tests (i.e., scripts) did your â€Å"Intense Scan† definition perform? List them all after reviewing the scan report. The Intense Scan initiated 36 Scripts. The scripts can be found at http://nmap.org/nsedoc/ 8. Describe what eachRead MoreDhl Marketing Mix22718 Words   |  91 Pages...................................................................................................................... 5 Mission and Vision Statements ................................................................................................ 7 Current Market ......................................................................................................................... 8 Measures of Performance.....................................................................................