a guide to mysql ch several Essay

CIS 331 – Database software Using SQL

Week six Homework -- Due: Week 7

Identity ¬¬¬

1 . Review Concerns – page 207 (A Guide to MySQL – Section 7) Inquiries 1 - 19 (type out the answers)

2 . Premier Products – internet pages 207 - 209 (A Guide to MySQL – Part 7) Physical exercises 1 – 9 (create in MySQL)

Except where indicated, employ MySQL Query Browser to execute each procedure and printing the benefits.

3. Henry Books – pages 209 (A Guide to MySQL – Chapter 7) Exercises 1 – 9 (create in MySQL)

Apart from where mentioned, use MySQL Query Internet browser to perform every single operation and print the results.

Predicted Completion Period: ___________ Feedback: _______________________________

Lab Assignment Quality: ___________

Verified simply by Instructor: ___________

Staple this page to all of your homework, every homework should be turned in simultaneously.

1 . A picture in the database intended for the user or an application. 2 . CREATE WATCH

3. The query intended for displaying the proper view

some. The user is only able to get a piece of the database, but all the information remains to be located within the tables. It is just not obvious. 5. Reliability of data, simplicity for removing extra details and the ability to better examine data. 6th. Ones wherever permissions have not been naturally

7. DROP VIEW

almost 8. GRANT

on the lookout for. REVOKE

twelve. A device for elevating efficiency in a database when you use queries 14. CREATE INDEX CREATE EXCEPTIONAL INDEX

12. DROP INDEX

13. DBMS

14. DISPLAY TABLES, DISPLAY COLUMNS

15. SHOW INDEX

16. PRESENT GRANTS

18. A rule for your data within the database to prevent incorrect additions. 18. During the MAKE TABLE order, but could be modified making use of the ADD PRIMARY KEY command 19. PUT FOREIGN KET

Premere Goods

mysql> CREATE VIEW MAJOR_CUSTOMER (CUSTOMER_NUM, CUSTOMER_NAME, BALANCE, CREDIT_LIMIT, REP_NUM) AS SELECT CUSTOMER_NUM, CUSTOMER_NAME, BALANCE, CREDIT_LIMIT, REP_NUM FROM CLIENT WHERE CREDIT_LIMIT SELECT 5. FROM MAJOR_CUSTOMER WHERE CREDIT_LIMIT < HARMONY;

+--------------+---------------------+---------+--------------+---------+ | CUSTOMER_NUM | CUSTOMER_NAME | BALANCE | CREDIT_LIMIT | REP_NUM | +--------------+---------------------+---------+--------------+---------+ | 408 | The Anything Shop | 5285. 00 | 5000. 00 | 35 | | 842 | Almost all Season | 8221. 00 | 7500. 00 | 20 | +--------------+---------------------+---------+--------------+---------+ two rows in set (0. 00 sec)

mysql> SELECT CUSTOMER_NUM, CUSTOMER_NAME, BALANCE, CREDIT_LIMIT, REP_NUM COMING FROM CUSTOMER WHEREVER CREDIT_LIMIT < BALANCE AND CREDIT_LIMIT GENERATE VIEW PART_ORDER (PART_NUM, DESCRIPTION, PRICE, QUOTED_PRICE, ORDER_NUM, DAY, NUM_ORDERED) AS -> SELECT PART. PART_NUM, DESCRIPTION, VALUE, QUOTED_PRICE, PURCHASES. ORDER_NUM, ORDER_DATE, NUM_ORDERED

-> FROM ORDERS, ORDER_LINE, PART

-> WHERE PART. PART_NUM = ORDER_LINE. PART_NUM AND ORDERS. ORDER_NUM = ORDER_LINE. ORDER_NUM; Issue OK, 0 rows affected (0. 00 sec)

mysql> SELECT PART_NUM, DESCRIPTION, ORDER_NUM, QUOTED_PRICE VIA PART_ORDER WHEREVER 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. ninety five

| CD52 | Microwave Oven | 21617 | 150. 00

| DR93 | Gas Selection | 21619 | 495. 00

| KV29 | Fitness treadmill | 21623 | 1290. 00

+----------+----------------+-----------+--------------+

almost eight rows in set (0. 00 sec)

mysql> SELECT PART. PART_NUM, DESCRIPTION, PURCHASES. ORDER_NUM, QUOTED_PRICE NUM_ORDERED -> FROM INSTRUCTIONS,...

References: BOOK(PUBLISHER_CODE);

Query OKAY, 33 rows affected (0. 05 sec)

Records: 33 Duplicates: 0 Warnings: zero

Description Essay