a guide to mysql ch 7 Essay

Words: 1272
Pages: 6
Open Document
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…
GRANT ALL ON PART TO ASTON;
GRANT UPDATE (ALL) ON ORDERS, ORDER_LINE TO KELLY, MORGAN;
GRANT UPDATE (PRICE) ON PART TO JAMES;
GRANT DELETE (ALL) ON CUSTOMERS TO DANIELSON;
GRANT SELECT (CUSTOMER_NUM, CUSTOMER_NAME, STREET, CITY, STATE, ZIP ) ON CUSTOMER TO PUBLIC;
GRANT INDEX ON ORDERS TO PEREZ;
GRANT ALTER ON PART TO WASHINGTON;
GRANT ALL ON ORDERS TO GRINSTEAD;

5. REVOKE ALL FROM ASTON
6. mysql> CREATE INDEX PART_INDEX1 ON ORDER_LINE(PART_NUM);
Query OK, 8 rows affected (0.58 sec)
Records: 8 Duplicates: 0 Warnings: 0

mysql> CREATE INDEX PART_INDEX2 ON PART(CLASS);
Query OK, 10 rows affected (0.01 sec)
Records: 10 Duplicates: 0 Warnings: 0

mysql> CREATE INDEX PART_INDEX3 ON PART(CLASS, WAREHOUSE);
Query OK, 10 rows affected (0.42 sec)
Records: 10 Duplicates: 0 Warnings: 0

mysql> CREATE INDEX PART_INDEX4 ON PART(CLASS DESC, WAREHOUSE);
Query OK, 10 rows affected (0.01 sec)
Records: 10 Duplicates: 0 Warnings: 0

mysql> DROP INDEX PART_INDEX3 ON PART;
Query OK, 10 rows affected (0.00 sec)
Records: 10 Duplicates: 0 Warnings: 0

SHOW TABLES;
SHOW COLUMNS FROM PART;
SHOW INDEX FROM PART;
SHOW GRANTS FOR ASHTON;

mysql>
Show More

Related Documents: a guide to mysql ch 7 Essay

Systems: Sql and Database Management Systems Essay

ch 7 Systems 1. When doing a traditional file you can make an error and it could be wrong in more than one location making it a huge problem. Also it takes up tons of space which means money. 2. A database typically stores data values in tables. Databases offer a greater range of complexity in terms of data manipulation. With database management systems, several people can access the same data set. 3. Database management system is a software that manages database on a computer. Eg. Microsoft…

Words 400 - Pages 2

Five Applications And Tools Pre-Loaded On The Tfttwindows01 Server Desktop

1. Name at least five applications and tools pre-loaded on the TargetWindows01 server desktop, and identify whether that application starts as a service on the system or must be run manually. WINDOWS APPLICATION LOADEDSTARTS AS SERVICE Y/N 1. tftpd32 Starts as a service 2. FileZilla Server Interface- The interface does not start as a service and must be ran manually 3. Wireshark – Does not start as a service and must be ran manually 4. Nessus Server Manager – Does not start as a service and…

Words 11873 - Pages 48