a guide to mysql ch 7
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: ___________ Verified by Instructor: ___________
Staple this page to all of your homework, all homework must be turned in at the same time. 1. A picture of the database for the user or an application.
2. CREATE VIEW
3. The query used for displaying the correct view
4. The user is only able to see a piece of the database, yet all the information is still located within the tables. It is just not visible.
5. Security of data, simplicity for removing extra information and the ability to better examine data.
6. Ones where permissions have not been granted
7. DROP VIEW
8. GRANT
9. REVOKE
10. A mechanism for increasing efficiency in a database when using queries
11. CREATE INDEX CREATE UNIQUE INDEX
12. DROP INDEX
13. DBMS
14. SHOW TABLES, SHOW COLUMNS
15. SHOW INDEX
16. SHOW GRANTS
17. A rule for the data within the database to prevent incorrect additions.
18. During the CREATE TABLE command, but can be modified using the ADD PRIMARY KEY command
19. ADD FOREIGN KET Premere Products
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 CUSTOMER WHERE
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: ___________ Verified by Instructor: ___________
Staple this page to all of your homework, all homework must be turned in at the same time. 1. A picture of the database for the user or an application.
2. CREATE VIEW
3. The query used for displaying the correct view
4. The user is only able to see a piece of the database, yet all the information is still located within the tables. It is just not visible.
5. Security of data, simplicity for removing extra information and the ability to better examine data.
6. Ones where permissions have not been granted
7. DROP VIEW
8. GRANT
9. REVOKE
10. A mechanism for increasing efficiency in a database when using queries
11. CREATE INDEX CREATE UNIQUE INDEX
12. DROP INDEX
13. DBMS
14. SHOW TABLES, SHOW COLUMNS
15. SHOW INDEX
16. SHOW GRANTS
17. A rule for the data within the database to prevent incorrect additions.
18. During the CREATE TABLE command, but can be modified using the ADD PRIMARY KEY command
19. ADD FOREIGN KET Premere Products
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 CUSTOMER WHERE
References: BOOK(PUBLISHER_CODE); Query OK, 33 rows affected (0.05 sec) Records: 33 Duplicates: 0 Warnings: 0