CIS336 iLab Week 7

$11.50

CIS336 iLab Week 7
There is a lot more to a database than just tables and the data in them. A very important part of database…

SKU: CIS336 iLab Week 7 Categories: , Tags: , , ,

Description

CIS336 iLab Week 7

CIS336 iLab Week 7

A+

Working With Views

There is a lot more to a database than just tables and the data in them. A very important part of database security has to do with using and understanding Database Views. Lab 7 will introduce this concept. Make sure to follow the instructions provided in the Lab instructions.

The Student Answer Sheet file that you will download below provides a place for the answer to each problem.  You will copy and paste this information from your MySQL environment. Be sure your name, course number, and lab number are in your file which will be submitted to the iLab Dropbox for Week 7.

This lab will utilize the tables that were created in Lab 4. If you have not yet created these tables,you can create the database and tables (used in Labs 4–7) by downloading the following files.

(Instructions)

(Database Script)

Follow the instructions to complete the Lab by downloading the following files.

Be sure to refer to the ERD for the database in…when creating your queries.